news [mailto:[EMAIL PROTECTED] Behalf Of Sven K�hler wrote:
> hi,
>
> 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.
>
>
Perhaps
declare ordertab cursor for select col1 from table2 order by col1
+
insert into table1 (col2) select * from ordertab
may help
Elke
SAP Labs Berlin
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
