>>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
>
>I would recommend opening ALL tables with ALIAS then referring to the alias.
>
>USE table1 IN 0 ALIAS FileOne
>USE table2 IN 0 ALIAS FileTwo
>
>You can then open as many tables as you like with the same name. Personally, I even include alias when it is the same as the table name - to force the habit.

Enforce the directory to work efficiently.

USE first_dir\table1 IN alias1
USE second_dir\table1 IN alias2

SELECT alias1
blah...blah...blah...
SELECT alias2
blah...blah...blah...