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
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
er
-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
3 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:
-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 databas
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 se
Is there any way to have a single select statement that can do a join
across two databases on the same server?
Thanks
