Joining to multiple database

[Jhankins]

i am using Query Analyzer and wish to join to another database.

select c.x,c.y
from
db1.db.tble c

join db2.db2.tble x on
c.x = x.x
where
x.batch like 'me%'

i am using SQL 2000 .. any help would be good

 

[SonOfEmidec1100]

Minor adjustments

select c.x,c.y
from db1..tble c
INNER JOIN db2..tble x on c.x = x.x
where x.batch like 'me%'

 

[SonOfEmidec1100]

I should have added -
This assumes they are on the same SQL Server instance.

 

[JamesLean]

Slight clarification:

To fully qualify an object name you can refer to it in the form: database.owner.object_name.

So in your example you might use: db2.dbo.tble.

However, if the owner is dbo then you can omit it, as in SonOfEmidec1100's answer.

--James