to my knowledge this is not possible in MySQL. There are only joins at the table level. I've been curious about this in the past myself, so if i'm incorrect, i'm hoping to hear it via this post.
hth
jeff
Moshe Weitzman
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
ourmet.org> cc:
Subject: [PHP-DB] join across
databases - how to select databases?
08/22/2003 11:16 AM
I have looked all over the web but can't find an example *in php* for
connecting to a mysql server, selecting database(s), and issueing a query
which joins across databases. I already know the SQL required to achieve a
multiple database query. My question is about how many calls to
mysql_select_db() are required, does order matter, etc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
