In my BOM table, I have "PARENT" numbers that have multiple lines with different "PARTNUMBER". The PARTNUMBER are units needed to repair the PARENT. Example, a PARENT will take 10 unique PARTNUMBER to repair so the one PARENT will have 10 lines in the table. The 10 lines will all have the same PARENT but each line will have a unique PARTNUMBER. Ok, here is my question
Sometimes I need to replace a PARTNUMBER with a different PARTNUMBER. Here is what I normally run:
set PARTNUMBER = '182649'
where PARTNUMBER = '2-009V747-75'
I have no problem with this and it works perfectly.
Here is my problem. I now need to modify all the PARENT's that have these three PARTNUMBER's in them ('801087008','801087009','801087010') and update to one PARTNUMBER = 'KGK002'.
If effect, I will have the query search for all PARENT's that have all three of these PARTNUMBER's('801087008','801087009','801087010') , erase the three lines, and replace with one line....PARTNUMBER ='KGK002'. How should I write the update statement please?