title: Oracle SQL error - Single-row subquery returns more than one row
body: <pre><code>    UPDATE Table_A
  SET Column_A = 
  (SELECT Table_C.Column_C
  FROM
      Table_A
  INNER JOIN  
      Table_B
  ON
      Table_A.Column_A1 = Table_B.Column_B
  INNER JOIN
      Table_C
  ON
      Table_B.Column_B1 = Table_C.Column_C1
  WHERE
     Table_C.Column_C2 &lt;&gt; 'T' and 
     Table_C.Column_C3 = 'T' and 
     Table_B.Column_B2 = 'T' and Table_B.Column_B3 = 'xyz');
  </code></pre>
  
  <p>I’ve a subquery in the brackets returning 10 values which I want to update Table_A with. 
  But the update statement only wants one value being returned from the sub-query:</p>
  
  <blockquote>
    <p>ORA-01427: single-row subquery returns more than one row</p>
  </blockquote>
  
  <p>How could I update several rows instead of just one?</p>
  
  <p>Any threads I've seen on this error do not help resolve the issue.</p>
  
  <p>EDITED - Would there be a way to do this using a loop?</p>