AND ??????????.sob_effective = (select Max(sob_effective) >>> from ScheduleOfBenefits t2 >>> where t2.sob_benfk = t1.sob_benfk >>> and t2.sob_codfk = t1.sob_codfk >>> and t2.sob_effective <= '20120801') Tbl1 >>> >>> ON [BenefitCodes].Ben_pk = Tbl1.sob_benfkOK, I saw the other changes you made.