Multi database query..

[Anon]

Hi,
How is it possible to do a multi database query in MSSQL? (or any SQL for that matter)
For example I have an Id in one database that has an Id which I can lookup in another database.
I guess it is something like this
SELECT field from db!table where myfield = (SELECT myfield from otherdb!table)

any ideas??

[btubalinal]

Use qualified names:

SELECT field FROM db_1.dbo.table
WHERE field =
(SELECT myfield FROM db_2.dbo.table);

RTM for a better explanation.

BT