>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.