I know that at least with MySQL you can use: SELECT database1.table1.field1, database1.table.2.field1, database2.table1.field1, database2.table2.field1 FROM database1.table1, database1.table2, database2.table1, database2.table2 WHERE ...
--TWH -----Original Message----- From: Pascal Gravot [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 5:51 PM To: [EMAIL PROTECTED] Subject: sql problem Hi Sorry I saw you comment on sql and I have a small problem that I cannot resolve Is it possible to query mutiple databases with one sql statement? I'd like to query around 100 database and I'm interesting by only one table (same name on all of the 100 databases) and inside of the table I want only 3 fields I have 100 databases 1 table on each call table_name and the field field1, field2, field3(same for all databases) Could you help me on this Thanks for u time Best regards Pascal Gravot Guatemala
