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 ea
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
w
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 wro
"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
> db
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 [
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
