Remote SQL databases

[Bob Sneidar]

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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution