Sven K�hler wrote: > > > declare ordertab cursor for select col1 from table2 order by col1 > > + > > insert into table1 (col2) select * from ordertab > > The same is also possible with sub-selects: > > INSERT INTO table1(col2) SELECT * FROM > (SELECT col1 FROM table2 ORDER BY col1) > > Sorry i bothered you with this. >
Sorry, but your answer is not correct. FROM (<query expression>) and <query expression> does NOT include ORDER BY ... --> your insert select will fail with syntax error Elke SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
