Create query using two databases

alex95sv

New Member
I am developing a web application (using classic asp for now) that needs to query two tables on two separate databases on the same server.I have been given separate application-level login/passwords for each database by the IT team which will be used in my code to connect.I want to create a query that links two tables (one from each database) together, but not too sure how, and Google hasn't helped me much either. I'm assuming I have to create two connections to do this as I have two separate logins, but how then would I create a query that uses tables from each.Just a note - our IT team will not at this stage link the two databases together. I'm pretty much stuck with what I have.Hope you can help.Mat
 
Back
Top