Query on 2 bases

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

Thanks in advance.

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

John
"TNR" <stage7@.tgs.fr> wrote in message
news:bg38re$u6c$1@.news-reader5.wanadoo.fr...
> How to make a query which contains fields from two different bases ?
> Thanks in advance.
> ReN|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<3f252ad9$0$18494$ed9e5944@.reading.news.pipex.net>...
> This request was posted earlier today under the title "Inter-Database
> References"
> John
> "TNR" <stage7@.tgs.fr> wrote in message
> news:bg38re$u6c$1@.news-reader5.wanadoo.fr...
> > How to make a query which contains fields from two different bases ?
> > Thanks in advance.
> > ReN

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