re: how to join two tables in different server

2002-10-23 Thread Egor Egorov
Vivian, Wednesday, October 23, 2002, 5:24:13 PM, you wrote: VW> I like to have a query like this, VW> select * from tableA left join tableB on. VW> But tableA is in hostA, and tableB is in hostB. VW> What I should do? I can use either PHP or python. VW> Any ideas? Vivian, if your tables are l

Re: how to join two tables in different server

2002-10-23 Thread Paul DuBois
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:

Re: how to join two tables in different server

2002-10-23 Thread gerald_clark
You can't do that. You will have to open two connections, and do nested loops to build your result set. 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 PH