Query from 2 or more databases
Posted: 18.12.2011, 16:23
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
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