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