how do write a sql query that joins a table in one database to a table located in another database in the same SQL Server

Question

how do write a sql query that joins a table in one database to a table located in another database in the same SQL Server

Answer 1

Hi,

Here is sample select query:

select e.emp_no,e.emp_name,e2.added_date

from Database1.dbo.Table1 e

inner join Database2.dbo.Table2 e2 on e.id=e2.id

Further you may get help from below link:

https://datatofish.com/join-tables-different-databases-sql-server/#:~:text=To%20join%20tables%20from%20two%20different%20databases%20in,tb_1%20JOIN%20%5Bdatabase_2%5D.%5Btable_schema%5D.%5Btable_name_2%5D%20tb_2%20ON%20tb_1.id%20%3D%20tb_2.id