update ... easy one

ok guys... I am starting to go blind staring at a supposed to be simple update:

this is what i want to do:
update c

set c.ID_PARENT = ID_NEW_PARENT

where c.id_parent = w.id_curr_parent

AND id_child = w.id_curr_child

where c is the to be updated table and w contains the values for the update...

getting lost ...

pls help

M Received on Wed Oct 30 2002 - 13:37:47 CST