AW: Inserting a select statement result into another ta ble

> > > He does ask a legitimate question though. If you are 
> going to have a
> > > LIMIT feature (which of course is not pure SQL), there 
> seems no reason
> > > you shouldn't be able to insert the result into a table.
> > 
> > 
> 
> This is an interesting idea.  We don't allow ORDER BY in 
> INSERT INTO ...
> SELECT because it doesn't make any sense, but it does make sense if
> LIMIT is used:

An "order by" also makes sense if you want to create a presorted table
for faster access. I don't see why we should disallow it.

Andreas