List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 6 1999 4:45am
Subject:Re: join across databases?
View as plain text  
On Wed, May 05, 1999 at 09:36:25PM -0700, Daevid Vincent wrote:
> Is it possible to join across databases?

Yes, it is.  You can find the information in the manual.  In short,
you prefix the table name with the database name:

SELECT l, p FROM db1.tableA, db2.tableB WHERE db1.tableA.m > db2.tableB.q

Tim
Thread
join across databases?Daevid Vincent6 May
  • Re: join across databases?Thimble Smith6 May
  • Re: join across databases?Daevid Vincent6 May
    • Re: join across databases?Thimble Smith6 May
  • Re: join across databases?Daevid Vincent6 May
    • Re: join across databases?Chuck6 May
      • Re: join across databases?Thimble Smith7 May
  • Re: join across databases?kalle volkov6 May