Accessing table to different server

Hi all,
Is there a way to connect to a table which resides in a different server in
the same network? What I am trying to do is to have a union function
between 2 tables, 1 table in SQL Server A, and the other in SQL Server B.
Thanks in advance.
Sol
You have to create a link to the other server and then do the join through
the link.
"Sol" <ssantoso@.eulogix.com> wrote in message
news:uqqgvBy$EHA.3840@.tk2msftngp13.phx.gbl...
> Hi all,
> Is there a way to connect to a table which resides in a different server
> in
> the same network? What I am trying to do is to have a union function
> between 2 tables, 1 table in SQL Server A, and the other in SQL Server B.
> Thanks in advance.
> Sol
>