title: SQL query - Can I not do this?
body: <pre><code>update TABLE set A = (
  SELECT
      CASE
          WHEN B - C &gt;= A  THEN A
          WHEN B - C &lt;  A THEN B - C
      END AS A
  from 
  TABLE )
  </code></pre>
  
  <p>The response I get is : </p>
  
  <p>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.</p>