Re: Query across two databases on the same server

[Hassan Schroeder]

Ed Reed wrote:

yea, I thought it would be that easy too but it doesn't work.
Other than the fact that the given example needs a "FROM" clause,
sure it works. What exactly are you trying and what is the exact
"incorrect" result?
select 
db1.table.field, db2.table.field
  FROM db1.table, db2.table
where 
db1.table.someotherfield = db2.table.someotherfield
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
                          dream.  code.



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