title: Alter Update Statement SQL
body: <p>How would i alter this update statement so that if the value was not found in the <code>GENDERSPELLING</code> table the <code>GENDER</code> would be set to 'U'?  </p>
  
  <pre><code>UPDATE DWCUST DW
  SET GENDER = (SELECT NEW_VALUE FROM GENDERSPELLING GS
                WHERE DW.GENDER = GS.INVALID_VALUE)
  WHERE GENDER NOT IN ('M', 'F');
  </code></pre>