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 query like this:
>
> Select Database1.table1.field1, database2.table1.field1,
> database2.table2.field2 FROM database1.table1, database2.table1,
> database2.table2
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php