Joining Tables from Multiple DBs

[Anon]

On a project i am working on I have split our contacs database, our scheduling database, our jobinformation database, and our accounting database in order to keep the program modular.. What I need to know is how can I do a query (mysql/PHP) were I join tables from say, DB1.job and DB2.contacs Where DB1.job.contact_id=DB2.contacs.contact_id

what or how do I connect to the DBs, currently I have an include that connects to each DB as a different user and I specify in my select statements which one I am using
EX:: $a = $main->Select("sql statement");

Thanx in advance..

Chris

[jordan]

Though I've never done this before, I can only assume that you do this in the same way that you join two tables in the same database, but instead of using table1 and table2, use DB1.table and DB2.table.