An interesting question about joining two databases

If these databases are on the same server/instance you can do this using three part name syntax, see below.

select            
    D.*            
    ,N.*            
from            
    DataMart.dbo.TablefromDataMart D            
join            
    Northwind.dbo.Employees N            
on            
    D.KeyField = N.KeyField