SELECT ID, Status
 FROM Tasks AS T1
 WHERE 
   EXISTS
    (SELECT * 
       FROM Tasks AS T2
       WHERE (T1.ID = T2.ID) AND (T2.Status = 'Recorded') -- OK
     UNION
     SELECT *
       FROM Tasks AS T3
       WHERE (T1.ID = T3.ID) AND (T3.Status = 'Assigned'))