>>>

		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_benfk

OK, I saw the other changes you made.

I am getting a syntax error: "Incorrect syntax near Tbl1" and the red squiggly underline near the first occurrence of Tbl1 in the section I quoted above.

I am not familiar enough with this syntax to see what is wrong here, do you?