> Try this one:
>
> select x.* from (
>   select something, anotherthing,
>   (select sum(thirdthing) from second b where b.something = a.something)
> total
>   from a
> ) x where x.total > 10

While all of the suggestions are appropriate for an immediate work around, the OP original point is still valid.

Firebird engine should be doing a better job of analyzing queries and looking to reduce the unrequired loop/sub-queries due to duplicate sub-queries.


Sean
s