I wish to merge data of 2 same tables but located in
different SQL server within the same LAN.
Is there a way to call these 2 tables at the same time
in SQL Analyzer ? such as:

Select * From \\SQL1\table1 Union All Select * from \\SQL2\table2