Hi, in the reference manual of SAP DB you find the answer. The insert syntax looks like
<insert_statement> ::= INSERT [INTO] <table_name> [(<column_name>,...)] VALUES (<extended_expression>,...) [<duplicates_clause>] | INSERT [INTO] <table_name> [(<column_name>,...)] <query_expression> [<duplicates_clause>] | INSERT [INTO] <table_name> SET <set_insert_clause>,... [<duplicates_clause>] So your insert select should look like insert into tax (chartid,rate) select id, 0.07 from chart where accno = 2310 HTH, Holger SAP Labs Berlin -----Original Message----- From: hello hello [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 17. Oktober 2001 09:12 To: [EMAIL PROTECTED] Subject: problem on execute sql statement when I execute the following SQL statement : insert into tax (chartid,rate) values ((select id from chart where accno = 2310),0.07) error message : Native error: -5016 Text: [SAP AG][SQLOD32 DLL][SAP DB]Genernal error;-5016 POS(48) Missing delimiter: ). please help to solve. __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com
