title: Create query using two databases
body: <p>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.</p>
  
  <p>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.</p>
  
  <p>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.  </p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Hope you can help.
  Mat</p>