At 9:41 -0500 10/23/02, gerald_clark wrote:
You can't do that.
You will have to open two connections,
and do nested loops to build your result set.
Or copy one table to the other server temporarily. This can be
useful if you need to run a lot of joins between the tables.
Vivian Wang wrote:
MySQL,
I like to have a query like this,
select * from tableA left join tableB on.....
But tableA is in hostA, and tableB is in hostB.
What I should do? I can use either PHP or python.
Any ideas?
Thanks
---------------------------------------------------------------------
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
