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@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