Posted by Tom Moreau on 01/24/06 16:03

Use 3-part naming:

select
*
from
dbo.MyTable l
join
OtherDB.dbo.OtherTable o on o.PK = l.PK

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"Captain Nemo" <nemo@nospam.com> wrote in message
news:6oqBf.8267$wl.3901@text.news.blueyonder.co.uk...
Hi

I'm working on an ASP project where the clients want to be able to
effectively perform SELECT queries joining tables from two different
databases (located on the same SQL-Server).

Does this involve creating virtual tables that link to another database, or
am I completely on the wrong track?

Any hints as to where I might find more information (buzz-words, etc.) would
be most appreciated.

Thanks

• Next in forum: Re: Joining tables in different databases
• Prev in forum: Joining tables in different databases
• Thread view: Re: Joining tables in different databases

[Reply to this message]