I need to UPDATE a Oracle DB. I am learning SQL, so please forgive my newbie question.
I have successfully created this Oracle SQL Query
Select person.personnum from person
join vp_allperson on
person.personnum = vp_allperson.personnum
where vp_allperson.employmentstatus = 'Terminated' and person.fingerrequiredsw = 1;
I would like instead of returning my results of personnum, I would like to update person.fingerrequiredsw from 1 to 0 if both the above conditions are true.
I am just not sure how?
Thank you for looking