Connect 2 Database at once

[mrzero01]

How I can connect 2 tables at once which this 2 tables are not in the same DB.

I am using Apache + PHP + ODBC + Progress.

Each DSN is only allow to connect 1 DB. So when I want to excute a SQL statement to seek data from 2 DB. How can I DO??

Many Thanks

[khaldryck]

if you can 't connect to both DB at the same time, maybe the best thing to do is to connect on the first, retrieve the needed informations, close the connection, then connect to the second DB and retrieve the informations there as well
put all those thing in tables then do your output.