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 be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.SFT_NUM" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.PART_NUM" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.WC_NUM" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.SUM(QTY_SCRAP)" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.INV_LOC" could not be bound.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "DAILY_SCRAP.SUM(SCRAP_TOT_COST)" could not be bound.

Msg 207, Level 16, State 1, Line 3

Invalid column name 'SUM(CH_UNIT_PER_HRS)'.