update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID
and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID)
The above does not work with the error
Msg 4104, Level 16, State 1, Line 4 The multi-part identifier "PCT.PART_ID" could not be bound. Msg 4104, Level 16, State 1, Line 5 The multi-part identifier "PCT.LOCATION_ID" could not be bound.
Please help. It's urgent.