query around databases

I need to query tables on different databases, which all reside on the same database server. How to do this?

is it db1.tablex inner join db2.tabley ?

Hi dear,

try this

db1.dbo.tablex inner join db2.dbo.tabley

Thanks

Best Regards,

Muhammad Akhtar Shiekh