Get data across databases sql server

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 🙂

Leave a comment