Andy, I didn't do the same thing noted in the article:

--Correlated INNER JOIN Attempt

SELECT

lvt.ID,

lvt.PhoneNumber,

lvt.CreateDate,

lvc.CallWindowStart,

lvc.CallWindowEnd,

lvc.LVCallDispositionID

FROM

LVTransaction lvt

INNER JOIN

(SELECT TOP 3 * FROM LVCall WHERE LVTransactionID = lvt.ID ORDER BY CreateDate DESC) lvc

on lvc.LVTransactionID = lvt.ID -- <<<<<<<<<<<<<<<< mine DOESN'T have this.

Mine isn't a correlated inner join, it's a simple correlated subquery. Note the <<<<<<<<<<<'s. In mine, the inner query will reference the outside query for each row in the outside query. There is no "JOIN.... ON... "