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 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
>
--
Besten Dank
Philip Markwalder
==============================
Markwalder Philip
Consultant
[EMAIL PROTECTED]
Trivadis AG
Kanalstrasse 5
CH-8152 Glattbrugg
Tel.: +41- 1-808 70 20
Fax : +41- 1-808 70 21
Mobile: +41-79-445 77 87
http://www.trivadis.com
==============================
---------------------------------------------------------------------
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