Mitko R�rup wrote: > I'm still playing around with SapDB, now my question is about > subqueries. > > I have two Tables, TEST and TEST2, now i want to insert values into > TEST2 by selecting a column from test. > > INSERT INTO TEST2 (NAME) VALUES (SELECT NAME FROM TEST) > > Now he is complaining a Missing Delimiter ")" on Position 41 > (after the > SELECT). (Errno: -5016).
INSERT [INTO] <table_name> [(<column_name>,...)] <query_expression> --> INSERT INTO TEST2 (NAME) SELECT NAME FROM TEST or INSERT [INTO] <table_name> [(<column_name>,...)] VALUES (<insert_expression>,...) where <insert_expression> ::= <extended_expression> | <subquery> and <subquery> ::= (<query_expression>) --> INSERT INTO TEST2 (NAME) VALUES ((SELECT NAME FROM TEST)) Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
