Query Nesting

[Anon]

I have a project where I query a DB for distinct account numbers and then I need to query another DB for all items that correlate to these account numbers. All data is stored in an array to be output later in the page. I cannot seem to get the queries nested correctly. Anyone have any insights into this? Thanks...

[Anon]

If you're using mysql you can select across databases by specifying their names before the table do this:

SELECT * FROM db1.acct, db2.acct_data WHERE acct.id = acct_data.acct_id

Where your tables look like this:

database db1:
table acct:
id INT
(other data)

database db2:
table acct_data:
acct_id INT
(other data)