joining tables from different servers

[mkp2004]

I need to query the data from 3 tables in 3 different servers.Basically a union of these 3 tables.please help me out

10.50.200.139 (server),order(database),table1
10.50.200.139\CIG (server),product(database),table2
10.50.100.142 (server),sales(database),table3

 

[donutman]

Look up "Linked Servers" in BOL and ask your next question.
-Karl

[red] Cursors, Triggers and User Definded Functions are part of the Axis of Evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[nigelrivett]

Which might be "should I do it".

This looks like a join rather than a union so the answer is probably no. Copy the other tables locally and join there.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[markVII]

Link the servers. Make sure the DTC (Distributed Transactions Coordinator) is up and running. Know ramifications (performance, resources etc).