| 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 Vincent | 6 May |
| • Re: join across databases? | Thimble Smith | 6 May |
| • Re: join across databases? | Daevid Vincent | 6 May |
| • Re: join across databases? | Thimble Smith | 6 May |
| • Re: join across databases? | Daevid Vincent | 6 May |
| • Re: join across databases? | Chuck | 6 May |
| • Re: join across databases? | Thimble Smith | 7 May |
| • Re: join across databases? | kalle volkov | 6 May |