Hi there,
A simple question which is maybe already answered. I need insert some data selected from table1 to table2. See the notes following:
table2 has columns:
total_1, total_2, total_3
I get data for table1 using select statement with result as
12
23
34
How can I insert them into table2 as
total_1 | total_2 | total_3 |
12 | 23 | 34 |
Thanks in advance.