SELECT A.ID, B.Name FROM DB1.dbo.Table1 A INNER JOIN DB2.dbo.Table2 B WHERE A.ID=B.ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)