@GrassHopper - I don' usually use OPENQUERY and a linked server works better if you have multiple developers who know standard join syntax but are not as knowledgeable about OPENQUERY.

@all - I found it very useful to create SYNONYMs for the four part access path. Cuts down on the typing and can be clearer.