title: query to update single row with multiple values
body: <p>I need to run the following update script</p>
  
  <pre><code>update table1 set col1 = 'xxxx', 
  col2 = (select cc.client_type
          from table2 t2, table3 t3, table1 t1
          where t2.col3='YYY' 
          AND t3.col4 != 'aaa'
          AND t3.col5 = 'Y'
  )
  </code></pre>
  
  <p>I am getting following error</p>
  
  <pre><code>Error report:
  SQL Error: ORA-01427: single-row subquery returns more than one row
  01427. 00000 -  "single-row subquery returns more than one row"
  </code></pre>
  
  <p>I am using Oracle 10g. <strong>Any help on this??</strong></p>