>>Hi,
>>
>>I am struggling with creating the following SQL UPDATE:
>>
>>I have table PART_LIST with the PK field PART_PK (int) and unique field PART_NO (char).
>>Another table is PART_AUDIT with FK PART_PK and FK PART_NO.
>>I want to update PART_AUDIT column PART_PK with NULL for those records that do not have an entry of PART_NO in the PART_LIST. That is, before I can set the FK constraint on PART_PK I need to eliminate all the invalid keys.
>>
>>I would appreciate any suggestions or some sample code.
>>
>>This is my attempt at the code
>>
>>

>>update PART_AUDIT set PART_PK = null where not exists (select PART_PK from PART_LIST where
>> PART_LIST.PART_NO = PART_AUDIT.PART_NO)
>>

>
>Your code seems to be fine. Although I would name the field Part_FK in the Part_Audit as it's not a PK field there.

I usually assign the same name to the field if it relates to the PK field of another table. This way, it makes it visually easy to "connect." Are you saying that you name the FK (in a child) table differently than the, say, Unique field, in the parent table?

Thank you for confirming that my code will work (this was my main concern before executing it on the customer database).