<div>
Yes. You can do it by creating a <a href="https://msdn.microsoft.com/en-us/library/ms188279(v=sql.110).aspx" rel="ugc">Linked Server</a> or using the <a href="https://msdn.microsoft.com/en-us/library/ms190312.aspx" rel="ugc">OPENROWSET</a> function to retrieve the data from the remote server.
</div>


Yes. You can do it by creating a Linked Server [https://msdn.microsoft.com/en-us/library/ms188279(v=sql.110).aspx] or using the OPENROWSET [https://msdn.microsoft.com/en-us/library/ms190312.aspx] function to retrieve the data from the remote server.

<div>
Following Vitor Montalvao and Jason clark's comments:<br />
<br />
Use linkedserver method: exec addlinkedserver to connect the two databases.<br />
then use this example that works for me:<br />
<br />

<pre><code id="code-20-41300425-1">with 
table1query as
(
  select col1 as col1,col2 as col2 from [server].[database].[dboschema].[tablename]
)
,
tabl2query as
(
  select col1 as col1,col2 as col2 from [otherserver].[otherdatabase].[otherdboschema].[othertablename]
)

select * from table1query
union all
select * from table2query</code></pre>
</div>


Following Vitor Montalvao and Jason clark's comments:

Use linkedserver method: exec addlinkedserver to connect the two databases.
then use this example that works for me:



with 
table1query as
(
  select col1 as col1,col2 as col2 from [server].[database].[dboschema].[tablename]
)
,
tabl2query as
(
  select col1 as col1,col2 as col2 from [otherserver].[otherdatabase].[otherdboschema].[othertablename]
)

select * from table1query
union all
select * from table2query

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have two tables in SQL on two different machines.<br />
Is it possible to join this table into one ?
</div>
</div>


Hi Experts,

I have two tables in SQL on two different machines.
Is it possible to join this table into one ?

SQL join two tables

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.