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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!