Remote SQL databases

Mark Stuart mstuart at adaptcrm.com
Fri May 21 20:04:57 EDT 2010


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



More information about the Use-livecode mailing list