>>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