As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join with
that temporary table.
Question is: what kind of an application do you have that you
need such a thing?
> Is it possible to join two tables from different databases that are located
> on different hosts?
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
