"IN" limitations

[scholari]

mysql>
select day from furqi where start in
(
select start from (select start as start,end as end,sum(somecol) as ss from furqi where day='2006/07/31' group by start) as sss group by start,end order by max(ss) desc limit 0,1
);

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

what i wanted to do is to select a day from a table where start has a particular value, and that value of start is obtained from a subquery. that subquery is executed successfully seperately. but gives this error when in subquery.

What are your views?? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[hannah]

What version of MySQL are you running ?

Is it just me, or is your subquery in the place where your tablename should be? Also, it looks like you are trying to order by a value - max(ss) - not a field. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[bachel]

subqueries in place of where a table should be is perfectly normal

however in this case the subqueries are very wacky

the innermost subquery has incorrect grouping

then the next outer subquery selects only start but groups by start and end, and references max(ss) which isn't allowed because ss isn't selected

i honestly can't figure out what the whole thing is trying to achieve -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --