Re: Error on Insert with Select

Do not put any parenthesis around the SELECT portion.

Kenny Gump

abrusko wrote in message <933265492.22891_at_www.remarq.com>...
>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!
Received on Thu Jul 29 1999 - 12:44:25 CDT