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.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
