Mark- 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 mwie...@ahsoftware.net _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution