i tried to insert something like
INSERT INTO table1(col2) SELECT col1 FROM table2 ORDER BY col1
but according to the grammer ORDER BY is not allowed.
well, you could say that the order of the rows doesn't matter, but it does. Imagine you've got a SERIAL-column in table1.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
