MySQL Operand should contain 1 column error?

Try removing the first occurrence of FROM Temp_4 (the one just after the second value in the subquery).

Try removing the first occurrence of FROM Temp_4 (the one just after the second value in the subquery). Edit: Also double check parenthesis groupings, as in this example: INSERT INTO table2 (field1, field2, field3, field4) (SELECT 'value1 from user input', field1, field2, field3 from table1) Which is given on this page regarding insert subqueries: dev.mysql.com/doc/refman/5.1/en/subqueri....

I tried your suggestion and below is my actual query. The query did not run successfully. I received the same error message.

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) ), pct_return_6) FROM temp_4; – user163129 Aug 26 '09 at 17:09 In the example I found, the select statement or subquery is completely enclosed in parenthesis. So on your statement, place an open parenthesis before "SELECT" and another after "FROM temp_4" hopefully that works for you. Subqueries are picky!

– JYelton Aug 26 '09 at 17:35.

Use: 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, pct_return_6 FROM temp_4; Mathematical order of operations ensures that brackets/parenthesis are not necessary.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.