title: mySQL Operand should contain 1 column error
body: <p>I am trying to run the query shown below to include the results in a report and am getting an <code>Operand should contain 1 column</code> error #1241. I have not been able to figure out the cause of this. If I run this part by itself I do not get any errors: <code>(pct_return_1 * .25) + (pct_return_2 * .25) + (pct_return_3 * .15) + (pct_return_4 * .15) + (pct_return_5 * .2)</code></p>
  
  <p>Here is the code: </p>
  
  <pre><code>DROP TABLE IF EXISTS temp_5;
  CREATE TABLE temp_5 (
      date_value date default NULL,
      pct_return_portfolio double default NULL,
      pct_return_benchmark double default NULL);
  
  INSERT INTO temp_5 (date_value, pct_return_portfolio, pct_return_benchmark)
  SELECT
   (date_value,
    (pct_return_1 * .25) +
    (pct_return_2 * .25) +
    (pct_return_3 * .15) +
    (pct_return_4 * .15) +
    (pct_return_5 * .2)
    FROM Temp_4),
  pct_return_6)
  FROM temp_4;
  </code></pre>