Figged it would be easy enuf.  Thanks

-- Keith

-----Original Message-----
From: Chris Boget [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 17, 2003 9:38 AM
To: Keith Hamilton; MySQL
Subject: Re: JOIN Statement on 2 Database Tables?

> Is it possible to Join 2 tables in 2 different databases?  Can someone
> give a quick example?

select database1.table1.* from 
database1.table1, database2.table2 where
database1.table1.common_field = database2.table2.common_field.

Chris
-mysql,query,blah

Attachment: smime.p7s
Description: S/MIME cryptographic signature

Reply via email to