Error on Insert with Select

Hi,

Can anyone please tell me what is wrong with the syntax of this query...I am getting the following error: ORA-00907: missing right parenthesis

Insert into Frt.Freight
(pro, frt_order, carrier, accrued, shipfrom, shipdate, shipto, customer, division, code, weight, value, cust_po, pc, cases, city, shippoint, pallets, bl, whse, cube, reldate, month, year, state, frt_mode)

   (Select (pro, frt_order, carrier, accrued, shipfrom, shipdate, shipto, customer, division, code, weight, value, cust_po, pc, cases, city, shippoint, pallets, bl, whse, cube, reldate, month, year, state, frt_mode) from Frt.Sardown
where (division = 'EXPORT' or division = 'SUBSIDIARY' or

          division = 'SAMPLES'));

Thank you!
Andy

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!