UNIDATA 7.1. I created a linked server named T4M. There is no problem with connection. Because I ran both queries seperately. It works.

I changed it to SCRAP. I got the same error message. It complains on each ON field.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.SFT_DATE" could not...