How do I query two tables in different databases on the same SQL Server?
In short, I want to do:
from database 1. table 1 as A
inner join database 2. table 1 as B
on A.COL1 = B.COL1
Both database 1 and 2 are on the same SQL Server.