>I need to insert records from one table to another, the tables have the same name, so the database, but they are in diferent directories.
>
>I open the first table and wend i try to open the second it always find the first table .
>
>What can I do to resolve this situation ?
>
>
>Thanks
>Carla

open with:

use tablename alias aliasname

then refer to the table by aliasname eg:

select * from aliasname, tablename where aliasname.key = tablename.key