Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL querry accross servers (and databases)

Author  Topic  kosc Starting Member 3 Posts Posted - 2001-07-03 : 10:43:37 Can someone tell me how to create SQL querry which will join tables accross different database (on same server) and accross different servers! All databases have same format. Is it possible something like: SELECT JohnServer@Base1.Table1.Name, BobServer@Base1.Table2.amount FROM JohnServer@Base1.Table1, BobServer@Base1.Table2 WHERE JohnServer@Base1.Table1.ID = BobServer@Base1.Table2.ID Kosc