Don't join on the WHERE, join with a JOIN
Select a.fld1, a.fld2, c.fld1, c.fld2, c.fld3 ;
from MasterTable a
join ChildTable c ON a.KeyField = c.KeyField
>Hi all
>
>Quite often, I use indirect referencing of tables in SQL statements,
>
>Select a.fld1, a.fld2, c.fld1, c.fld2, c.fld3 ;
> from MasterTable a, ChildTable c;
>where a.KeyField = c.KeyField
>
>
>I need the 'translation' of "MasterTable a, ChildTable c" in T-SQL
>
>Thanks
>
>Dorris
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer