View Single Post
  #2 (permalink)  
Old August 15th, 2003, 03:34 AM
owain owain is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Depending on the RDBMS you are using you may be able to qualify the table names with the database names.

Code:
DatabaseName.TableName.FieldName
So you could use the following SQL:

Code:
SELECT COUNT(Cust.phone_no), Sup.local_carrier
FROM customer.customers AS Cust, supplimental.table AS Sup
WHERE Cust.CarrierID = Sup.CarrierID
GROUP BY Sup.local_carrier
You may want to check my syntax, however the theory is there.

Regards
Owain Williams