Re: Query across two databases on the same server

[Michael Stassen]

It really should be that easy, though Peter's example is missing the FROM 
clause.  I'm sure he just meant to show the syntax for db.table.column 
rather than a complete query.

Why don't you tell us what version of mysql you have, the query you tried, 
and the result you got.

Michael

Ed Reed wrote:

yea, I thought it would be that easy too but it doesn't work.
 
Any other ideas?


"Peter Lovatt" <[EMAIL PROTECTED]> 3/24/04 3:53:03 PM >>>


select 
db1.table.field, db2.table.field
where 
db1.table.someotherfield = db2.table.someotherfield

Peter


-----Original Message-----
From: Ed Reed [mailto:[EMAIL PROTECTED]
Sent: 24 March 2004 23:45
To: [EMAIL PROTECTED]
Subject: Query across two databases on the same server
Is there any way to have a single select statement that can do a
join

across two databases on the same server?

Thanks






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]