View Single Post
  #1 (permalink)  
Old August 14th, 2003, 03:54 PM
nlicata nlicata is offline
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to nlicata
Default Multiple Database query

Dear Jason, :)

Is there any way to query 2 databases simultaneously in a single query? I do not have the ability to use views or stored procs, if they even would have helped.

The telcom company I am querying has our main customer db and the a supplimental db which holds a single table. The table is a relation between area codes, citys, and local carriers.

I am trying to get a count of phone numbers from my customer database and compare that list to the table mentioned above to get a count of how many of our customers are on each local carrier. Without the seperate DBs it would be a breeze but I cannot find a reference for multi-DB query in any of my resources.

Thanks in advance to whomever (prob Jason)...

Nick