Question - Accessing an external or remote database

[Eikinskjaldi]

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.