-- Fail when ISOK_RESULTS.Resolved and Deferred_To are both non-null UPDATE isok_results SET resolved = first_seen , deferred_to = first_seen WHERE iqname = 'query1';