>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

INNER JOIN?

Select a.fld1, a.fld2, c.fld1, c.fld2, c.fld3 ;
  from MasterTable a
INNER JOIN ChildTable c ON a.KeyField = c.KeyField