Link two tables from two separate databases from separate location

select * from Databasename1.dbo.tblEmployees t1
inner join OPENDATASOURCE('SQLOLEDB','Data Source=databasename;User ID=sa;Password=123').Databasename2.dbo.leave t2 on t1.Id = t2.Id