netcomander
Programmer
hi all,
I gat problems with table joins and I really urgently
need help, when the databases wich contain these
tables are not on the same server.
What works is a query like this:
select * from databaseA.tableX, databaseB.tableY
But what I need to manage is a query like
con1 = mysql_pconnect('192.100.0.22','sam','');
con2 = mysql_pconnect('192.105.0.3','corn','');
select * from con1.databaseA.tableX, con2.databaseB.tableY
Does anyone knows how to join tables over several mashines?
thanks in advance
greetings markus
I gat problems with table joins and I really urgently
need help, when the databases wich contain these
tables are not on the same server.
What works is a query like this:
select * from databaseA.tableX, databaseB.tableY
But what I need to manage is a query like
con1 = mysql_pconnect('192.100.0.22','sam','');
con2 = mysql_pconnect('192.105.0.3','corn','');
select * from con1.databaseA.tableX, con2.databaseB.tableY
Does anyone knows how to join tables over several mashines?
thanks in advance
greetings markus