Selecting from 2 different databases

gagansharma7 · June 27th, 2006, 01:59 PM

Hello Folks,

I have to select data from 2 different tables & 2 different databases, i am writing the following SQL. Its not working.

SELECT code1 FROM db1.dbo.tbl1
JOIN db2.dbo.tbl2.code2 ON db1.dbo.code1=db2.dbo.tbl2.code2

where
db1=database1;tbl1=table1 in db1;code1=fieldname in tbl1
db2=database2;tbl2=table2 in db2;code2=fieldname in tbl2

Please correct it.

Regards
gags!

jrogers · June 27th, 2006, 03:00 PM

try

Code:

SELECT code1 FROM db1.dbo.tbl1 
JOIN db2.dbo.tbl2.code2 ON db1.dbo.tbl1.code1=db2.dbo.tbl2.code2

gagansharma7 · June 27th, 2006, 04:30 PM

Yeah, i missed tbl1 there, i tried & it......didnt work.
It gives arror: db2 not found in sysservers
Do i need to use sp_addlinkedserver?

Thanks

jrogers · June 28th, 2006, 03:41 AM

yes