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
Ed Reed [EMAIL PROTECTED] wrote:
yea, I thought it would be that easy too but it doesn't work.
It should work.
Did you get error message?
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 =
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
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
I found the problem. There was a hyphen in my database name. Re-created
the database and re-imported my data, now everything works fine.
Thanks to everyone.
Egor Egorov [EMAIL PROTECTED] 3/25/04 8:19:04 AM
Ed Reed [EMAIL PROTECTED] wrote:
yea, I thought it would be that easy too but it
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
