insert statement problem

Dear all
I have two db table

Product (ProdID, ProdName,....Condition1)
ProdSellRec (ProdDetailID, ProductDesc,......ProductID)

When i would like to create a insert statement into second table!

insert into ProdSellRec
( @.ProductDesc,......@.ProductID)
where @.ProductID = (select ProductID from Product where ......[some condition]..)

Howver , the db want me "Unable to parse query text."/

What should I change my sql statement?

Thanks!

Ad_dee

it might be easier if you show your whole sql statement. It is hard to tell from that
|||

Thanks , i will post the sql later

But I would lile know whether the method of nested query is corrected in my sql.