LIMIT in subqueries

[Stephen Booth]

I just tried the following query:

select sum(sorties) from missions where sorties in (select sorties from missions limit 0,2);

and got the result

ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Is there another way I could accomplish a sum on a subset of rows from a table?

Other than this, the subqueries seem to work great!