Copying the entire remote table into a local temp table is not an option when the remote table has millions of rows. Have a look at the REMOTE join...