As allready suggested in http://www.dbasupport.com/forums/sho...threadid=30180 try forcing the join to be performed at remote site instaed of pulling both joined tables to your instance to be joined localy.

BTW, any particular reason why you opened a new thread for exactly the same problem you've posted couple of days ago (and which you didn't even bothered to comment after receiving couple of suggestions)?