Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement