[EMAIL PROTECTED] wrote: > Why my SELECT INTO does'nt work? Just a oversight? > > SELECT (Customer.CNO,'1', 'Luxus') INTO RESERVATION FROM Customer, > RESERVATION WHERE Customer.Guid='10AOPGH' > > > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > General error;-5016 POS(23) Missing delimiter: ). > SELECT ((Customer.CNO),'1', 'Luxus') INTO RESERVATION FROM Customer, > RESERVATION WHERE Customer.Guid='10AOPGH'
Select into is a way to retrieve a single tuple from the database. The syntax is described here http://www.sapdb.org/7.4/htmhelp/40/1311fd2fa511d3a98100a0c9449261/frameset.htm in your case it could look like SELECT (Customer.CNO,'1', 'Luxus') INTO :a, :b, :c FROM Customer, RESERVATION WHERE Customer.Guid='10AOPGH' But I assume you want to insert the result of the join into the table reservation, don't you? Then you should have a look at insert select like INSERT [INTO] <table_name> [(<column_name>,...)] <query_expression> [<duplicates_clause>] You'll find the complete insert syntax here: http://www.sapdb.org/7.4/htmhelp/34/ee7fb7293911d3a97d00a0c9449261/frameset.htm Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
