Quote:
Originally Posted by dcpaq2
Who said anything about having a programmer?
Doug
|
Funny.
If the dbs reside on the same server then mysql simply doesnt care, you can write the query directly
select db1.table1.field1, db2.table2.field2 from db1.table1
join db2.table2 on (db1.table1.field2 = db2.table2.field3)
if on a separate server you just need to set permissions on the remote server so that it can be accessed remotely, and set up a mysql connection that connect to remote.ip.address rather than localhost.