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