How join tables in multiple folders with Advantage Database Server

Using Advantage Database Server SQL, I need to be able to join free tables that are in separate folders. Is there a way to d开发者_如何学运维o this?

With free tables you can specify relative paths to the tables in the FROM clause.

SELECT * FROM "..\directory1\table1.adt" a, "directory2\table2.adt" b WHERE a.ID = b.ID;

This entry in the help files describes the basics of it.