Remote SQL databases

[Mark Stuart]

Hi Bob,
on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote: 
>>
So now I have to think about using joins.
<<
Just preface the table name that's in the other database with the
database_alias_name.table_name:

SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name
FROM database1.customers AS cus LEFT OUTER JOIN
database2.customer_types as ctyp ON cus.Customer_Type =
ctyp.Customer_Type_ID

HTH,
Mark Stuart