looks like you are joining data sets between linked servers.

Try selecting the data into a temp table first before doing the ANSI-1989 old school style joins with unions.