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:
>>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.