Sql query to join tables from different servers

1

sql query to join tables from different servers and different authenications.
one server is with windows authentication
other one is azure active directory-Integrated authentication

i Want to join the tables from these servers. Anyone can guide me to solve this issue

2

Create a linked server for the Azure server in your on-premises server. https://www.allaboutmssql.com/2018/02/how-to-create-linked-server-between-on.html

1 Like