How join tables in multiple folders with Advantage Database Server

Question

Using Advantage Database Server SQL, I need to be able to join free tables that are in separate folders. Is there a way to do this?

Answer 1

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.