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