I have two databases (db1 e db2) on different hosts (host1 e host2). I put them
on different hosts to split the charge (they are very big databases).
However, I have to make some selects on tables of db2 filtering with information
that are on db1.
If db1 and db2 were at the same machine, I wouldn't have problem, because the
table_reference would be "db1.table1 AS t1, db2.table2 AS t2". But as they are
on different machines, I didn't know the syntax of the table_reference or even
if it was possible.
Thanks,
Rodney
Werner Stuerenburg <[EMAIL PROTECTED]> em 10/07/2001 10:51:39
Favor responder a Werner Stuerenburg <[EMAIL PROTECTED]>
Para: RODNEY ANTONIO RAMOS RODNEYR/Embratel@Embratel
cc: [EMAIL PROTECTED]
Assunto: Re: Join syntax
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
