Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
(natural?) join question
Message
De
01/02/1999 13:46:30
 
 
À
01/02/1999 13:39:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00182610
Message ID:
00182628
Vues:
13
>>Using VFP 5.0a on WinNT 4.0 sp3.
>>
>>I want to do a select statement on two (or possibly more) tables where the results are based on an equal condition of a field from each table.
[stuff deleted]
>>TIA,
>>Marc Mandel
>
>If you join tables having fields with the same name and you want to guarantee output field names then you should use AS clause:
>Select a.id as aid, b.id as bid .... From a,b Where ....

Ed, Cetin,

Thank you both for your replies.

I did not realize that it was possible to combine a specific table_name.field_name with "*." This solves my problem.

Thanks again.
Marc Mandel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform