This can be achieved by joining the tables or indicating the tables using Fully Qualified names.
SELECT t1.id, t1.name
FROM AdventureWorks.dbo.Venkat_Table1 t1
INNER JOIN
AdventureWorksLT2008R2.dbo.Venkat_Table2 t2
ON t1.id = t2.id
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: