Take it from the top!

Ok. Sorry, I had a minor error in the WHERE Clause. I meant:

SELECT

lvt.ID,

lvt.PhoneNumber,

lvt.CreateDate,

lvc.CallWindowStart,

lvc.CallWindowEnd,

lvc.LVCallDispositionID

FROM

LVTransaction lvt

WHERE lvt.ID in ( --<<<<<<<<<<<<<<< THIS IS WHAT I MEANT

SELECT top 3 lvtTransactionID --<<<<<<<<<<<<<<<<<<< ANOTHER correction ... 🙂

FROM LVCall

WHERE lvtransactionID = lvt.ID

Order By CreateDate DESC

) as lvc