>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
Before issuing the SELECT, open the table in the other directory, explicitly assigning it a unique alias; that way, you can reference that table in a clearly-identifiable way in your SELECT statement.