When we want to query on remote database server along with the local database server then we can add the remote SQL server to local SQL server in a same group using the concept called Linked Server.

We can query on both servers using T-SQL.

We can use stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin to add new Linked Server.

By using Linked Server we can SQL statement in clean and easy way to retrieve, join and combine remote data with local data.