I have 4 local DBIsam databases - all with the same table names, structures, etc.  I would like to populate a grid with the customer lists from all 4 databases.  What would be the best way to accomplish this?  Is it possible to write one query against all 4 Databases at the same time?  An help would be greatly appreciated.

Sample:  select * from db_customers.dat

Kreg


Try something like

select * from "D:\MandN\Data"\BandA
UNION ALL
select * from "E:\NewsRdr\Data\"\BandA

Roy Lambert [Team Elevate]