TMA, human error when inputting on PDA

We have two inspectors that have got into bad habits. When doing street works sample inspection pass they have been selecting inapplicable instead of acceptable. This has now been addressed but we have a number of incorrect records.

Is there a clever way of changing the all the “passed” samples with a status type of 4 to 1 and resend the inspection notice?

The below select statement does give the expected results. Could it be a matter of changing the tili_status_type from 4 to 1 and setting the eton status to 1 (ready for sending). I have not tried to turn the below into an update because I believe oracle does not allow updating multiple tables in one query and I would always seek advice before making changes via SQL.

Select  tire_eton_status, t2.tili_status_type
From tma_insp_results_all t1
inner join tma_insp_result_lines t2 on tire_inspection_id= tili_inspection_id
WHERE t1.tire_date > '01-JAN-2014' and t1.tire_inspector_name like 'example inspector' and t2.tili_status_type='4' and t1.tire_outcome_type='1'