Hi,

May be values clause is missing there.

The syntax i remenber is :

Insert into table1 values
( select
.
.
.
..

);


Thanks
Penchal