SQLTeam.com | Weblogs | Forums

How to insert one row data from a select result


#1

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.