>Is there a way to create an SPT statement referencing a remote table and joining with a local table without using views (since that would negate the purpose of keeping the data on the server and making the server do the work)?

You can pull your result set back from the server using SPT and then join theat cursor to your local table. Does that help?