multiply two columns

[rony_78]

I am not programmer just learning, I have a table with ten columns; I want to multiply row by row between two columnsCol2 * col4 = col5 Col6 * col7 = col8 col 5 + col8 = col 9I know how to get this part Col2 * col4 = col5 Col6 * col7 = col8How do I write a query that will add another column with col5 + col8 = col9 SELECT col2, col4, col2 * col4 AS col5, col6, col7, col6 * col7 AS col8FROM Table1 WHERE < criteria> thanks in advance

[niche]

That would be an UPDATE. It's pretty simple to write. Let us know if you still need help. http://w3schools.com/sql/sql_update.asp

[rony_78]

Thanks -