>>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.
Ed: Thank you very much. I do like that solution of being able to reference the table in a clearly-identifiable way. I hate it when I have to try to follow others' work where they use the A.fieldname, B.fieldname, C.fieldname, etc. notation in the body of the SELECT statement. Thanks again!
Chuck Henry