Subject Re: [firebird-support] Request new feature - better perfomance
Author Virna Constantin

 “b on a.something = a.something” produce an error.


a.something=b.something  !!!


another option:
select a.someting, a.anotherthing, b.total
from first a inner join (
select someting,sum(thirdhing) as total
from second group by someting having  sum(thirdhing)>10 ) b on a.someting=b.someting