Remote SQL databases

Mark Stuart mstuart at
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

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 =

Mark Stuart

More information about the Use-livecode mailing list