merge variant (10g+):

merge into faults
using (select cf_id, ticket_state from incidents) incidents
   on (incidents.cf_id = faults.cf_id)
when matched then update
 set fault_state=ticket_state;


Update table with subquery and duplicates
It seems like building the Robocop was a really stupid business approach:


You can't build them on industrial scale (to put it somewhat insensitively, OCP didn't have a ready supply of highly trained and freshly killed police officers)

So, Robocop seemed like a prototype that could never have entered production. Total waste of R&amp;D money.
And having a police brain (because he already know police procedure) seems not necessary since at the same time OCP could build fully AI robots (from robot chicken, flawed as it was, in Robocop 1, to Ninja Androids in Robocop 3).

