Gotcha. Teaches me to take my web guy's word for it. :-) Bob
On May 21, 2010, at 5:04 PM, Mark Stuart wrote: > 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 > _______________________________________________ > 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 _______________________________________________ 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