Page 1 of 1

Query from 2 or more databases

Posted: 18.12.2011, 16:23
by Sapiem
Hello:

We have diferents databases, one per month, and we need query from all of them at the same time, for example, how many records are females.

Zeos doesn't work like this:

SELECT * FROM "path\january.db3".Clients, "path\february.db3".Clients WHERE Sex='Male';

Please we need solve this trouble (almost for us)

Thanks