How to make a query which contains fields from two different bases ?

Thanks in advance.

ReN

This request was posted earlier today under the title "Inter-Database
References"

John
"TNR" <stage7 (AT) tgs (DOT) fr> wrote

"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

If your databases are on the same server then it's as simple as:

select *
from database1..table1 inner join database2..table2

if they are on different servers, then you'll need to add a linked
server to the database that you are running your query on. This can
be done through the GUI or by running sp_addlinkedserver system stored
procedure. Once you've done it then, the command is:

select *
from database1..table1 inner join linkedservername.database2..table2

Hope this helps
Hodge