October 9th, 2012, 03:24 AM
Storing list of values which are returned by a select query?
I have a requirement like getting list of values from one table and inserting them into another table.
I have tried with sub querying but didn't worked out because the select query is returning multiple values.
Can any one please suggest how to proceed further and the ways how can I write this requirement.
October 9th, 2012, 04:34 AM
insert into table2 (select * From tabel1 where .......);
if required you also specify the desired list of columns.