You can ensure only rows with a match are updated like this:

update FAULTS
set FAULTS.FAULT_STATE = (
    select INCIDENTS.TICKET_STATE from INCIDENTS
    where INCIDENTS.CF_ID = FAULTS.CF_ID and rownum = 1
)
where exists (
    select INCIDENTS.TICKET_STATE from INCIDENTS
    where INCIDENTS.CF_ID = FAULTS.CF_ID
)


Update table with subquery and duplicates
Two gangsters are flying down I-70 West at a constant 108 hm/hr. If they make it to Indiana, they will be safe. When they are 1 km away from the Indiana border, while still traveling at a constant 108 km/hr, they pass a concealed police car hidden in a speed trap. At the instant that the criminals pass the patrol car, the cop pulls onto the highway and accelerates at a constant rate of 2 m/s^2. Does the cop catch up with them before they cross the state line?

Here's what I have progressed so far


  ΔV = (ΔX)/(T)
  
  when V is velocity, X is distance, and T is time.
  
  108 = (1 - 0)/T
  
  108T = 1
  
  T = 1/108
  
  T = 0.00925 hours
  
  T = 0.00925 * 60 * 60
  
  T = 33.33 seconds (this is the time it takes the gangsters to get to
  the borders of Indiana)


What I am stuck at is the time it takes the cop to travel the same distance. I have used the distance formula to find time as follows:


  Xf = Xi + 1/2 * A * T^2
  
  where A is acceleration
  
  Since the cop is starting from rest, the initial velocity is 0 (zero),
  so
  
  1 = 0 + 1/2 * (2) * T^2
  
  1 = T^2
  
  T = 1 seconds


So it takes the cop 1 seconds to travel the whole mile to Indiana? What am I doing wrong?
