Posted by Mel on 07/11/06 14:12

On 2006-07-11 21:58:26 +1000, Jerry Stuckle <jstucklex@attglobal.net> said:

> Dejan wrote:
>> Yeah right. I have tried playing with multidimensional arrays, buth with my
>> knowlege :))
>>
>> Why cann't i use this with what sql query?
>>
>>
>>
>>> You query table1 and table2 and store those in two multi dimensional
>>
>> arrays,
>>
>>> then you create your third multi dimensional array into where you store
>>
>> the
>>
>>> joint rows of table1 and table2.
>>>
>>>
>>> //Aho
>>
>>
>>
>
> Unless something has changed, you can't query across databases on
> different servers.
>
> Also, if you ask a question in a PHP group expect to get a PHP
> response. If you want a MySQL response, try a MySQL group such as
> comp.databases.mysql.

I don't know if it's valid SQL (or just T-SQL), but:
MSSQL supports connecting to multiple servers in a single statement. Ex:
select tbl1.*, tbl2.*
from localhost.mylocaldatabase.dbo.table_one as tbl1
join otherhost.myremotedatabase.dbowner.table_two as tbl2 on tbl1.id = tbl2.fk

[Back to original message]