Rodney -
You can't execute a query across two connections simultaneously.
If you must split the tables between two hosts, network then together
at the file system level so that the database directories are accessible
by one instance of MySQL. Then connect and query that instance...
\\|//
(@ @)
-------oOO---(_)---OOo--------
| |
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596.1443 |
| |
------------------------------
|__|__|
|| ||
ooO Ooo
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:58 PM
To: Werner Stuerenburg
Cc: [EMAIL PROTECTED]
Subject: Re: Join syntax
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
---------------------------------------------------------------------
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
