title: Oracle Update sql with left join null
body: <p>I tried to create the Oracle code to update the <code>STATUS = 'Resolved'</code> with left joint of <code>TBL_RPT_CONS_2.ERR_MSG1 = TBL_OPENJOB.ERR_MSG</code> where the <code>ERR_MSG1</code> on table <code>TBL_RPT_Cons_2</code> is null.</p>
  
  <pre><code>Update TBL_RPT_CONS_2 Status
   Set STATUS = 'Resolved'
   FROM TBL_RPT_CONS_2 TBL_RPT_CONS_2
    LEFT OUTER JOIN TBL_OPENJOB TBL_OPENJOB
        ON (TBL_RPT_CONS_2.ERR_MSG1 = TBL_OPENJOB.ERR_MSG)
    WHERE     (TBL_OPENJOB.ERR_MSG IS NULL)
     AND (TBL_RPT_CONS_2.DOLV_REPORT_NAME = 'ICS1500-4')
     AND (TBL_RPT_CONS_2.STATUS = 'Open')
  </code></pre>
  
  <p>I'm able to view it using select but unable to update it.</p>
  
  <pre><code>SELECT TBL_RPT_CONS_2.STATUS
    FROM HRD_DEV.TBL_RPT_CONS_2 TBL_RPT_CONS_2
         LEFT OUTER JOIN HRD_DEV.TBL_OPENJOB TBL_OPENJOB
            ON (TBL_RPT_CONS_2.ERR_MSG1 = TBL_OPENJOB.ERR_MSG)
   WHERE     (TBL_OPENJOB.ERR_MSG IS NULL)
         AND (TBL_RPT_CONS_2.DOLV_REPORT_NAME = 'ICS1500-4')
         AND (TBL_RPT_CONS_2.STATUS = 'Open')
  </code></pre>