title: Netezza Update a Table Column by Joining to Another Table
body: <p>I am getting an error by running an update, but I can not figure out where the issue is in Netezza. I appreciate some help.</p>
  
  <p>ERROR [42S02] ERROR:  relation does not exist DEVML_WORK.AGRINSHPUN.A</p>
  
  <pre><code> update Table A
      set A.COL1 = B.COL2 
      from A left outer join  B 
      on A.CU_NUM=B.CU_NUM;
  </code></pre>