Storing list of values which are returned by a select query?

Hi,

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.

Thanks
Lakshmi

try this.

insert into table2 (select * From tabel1 where .......);

if required you also specify the desired list of columns.