select a.col1, b.col2
from db1.dbo.tab1 a, db2.dbo.tab2 b
where a.col1 = b.col2
All you sql wizards prob know this alread 
Filed under: Applied IT
Get data across databases sql server
Posted on February 5, 2010 by mellerbeck
select a.col1, b.col2
from db1.dbo.tab1 a, db2.dbo.tab2 b
where a.col1 = b.col2
All you sql wizards prob know this alread
Filed under: Applied IT
