...because the join actually is taking place on the link in one case and brought local in the other.

Try using the driving_site hint.

- Chris