> 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
