Hi Chuck,
Supposing you have to join the tables, should this works?

SELECT t1.f1, t2.f1 FROM table1 t1 LEFT JOIN yourdir\table1 t2 ON t1.keyfield=t2.keyfield

if you don't need to join, I think the "from table1 t1..." and prefix fields name with t1.f1, t2.f1 will do the job

>I have a SELECT statement that compiles information from several tables. I need to add a table.field to the list in the SELECT statement; however, the tablename.fieldname is identical to one of the other tables in the SELECT..FROM list (it just resides in a different directory). How does one get around this? Would appreciate any help. TIA, Chuck