Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need another VFP ->SQL translation, please
Message
De
28/11/2012 15:08:45
 
 
À
28/11/2012 15:05:36
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01558276
Message ID:
01558281
Vues:
72
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform