Remote SQL databases

Mark Wieder mwieder at
Sat May 22 21:35:07 EDT 2010


Friday, May 21, 2010, 5:04:57 PM, you wrote:

> 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

Nice one - someone actually found a use for an outer join. I've
wracked my brain trying to come up with a situation where I'd want to
use one, and never come up with anything.

-Mark Wieder
 mwieder at

More information about the Use-livecode mailing list