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