ORDER BY in sub-query

Currently, monetdb fails on this query:

SELECT * FROM (SELECT * FROM "Batting" ORDER BY "playerID")

with

syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or ')' in: "select * from (select *

(obviously that query isn't very useful, but it makes it harder to automatically generate sql)

In case it matters, that query (with minor escaping variations) works in sqlite, postgres and mysql.

Hadley