Seems to me the right answer is missing -- Using the OpenQuery function. Using the syntax of the "correct" answer would cause really bad performance, because SQL Server will retrieve the whole salestable from the International server.
Sloan
If you can't do it in SQL, get a bigger hammer!
Sloan
If you can't do it in SQL, get a bigger hammer!