Join tables on different servers 1

[jcfowl]

I know how to join tables in different databases, but I can't seem to join tables that are on different databases and also on different servers. Is there anyway to do this? If anyone knows the syntax please let me know. Thanks.

 

[JohnDTampaBay]

The "different" server(s) must be set up as Linked Servers. Then you can use a four part object name to reference the remote table:

SELECT * FROM Server.Database.Owner.Object

See also OPENDATASOURCE and OPENROWSET in BOL. Good luck!

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)