Unfortunatly you can do this only on local databases. It would be very useful to also
request databases on different servers with one statement.
Philip
On Fri, 8 Jun 2001 17:19:34 -0600
Chris Bolt [EMAIL PROTECTED] wrote:
Try it =P (just don't forget the WHERE clause)
If you want to make
Can I do query like this:
Select Database1.table1.field1, database2.table1.field1, database2.table2.field2 FROM
database1.table1, database2.table1, database2.table2
François Boucher
[EMAIL PROTECTED]
Try it =P (just don't forget the WHERE clause)
If you want to make your query easier to write, use aliases:
SELECT d1t1.field1, d2t1.field1, d2t2.field2 FROM database1.table1 AS d1t1,
database2.table1 AS d2t1, database2.table2 AS d2t2 WHERE d1t1.id = d2t1.id
AND d2t1.id = d2t2.id
Can I do