Thank you for try, but now I have problem with recognition of first and second. Elements from subselect in inner join is not visible in main select and vice versa so “b on a.something = a.something” produce an error.
Best regards, Djordje From: mailto:[email protected] Sent: Monday, October 20, 2014 6:37 AM To: [email protected] Subject: Fw: [firebird-support] Request new feature - better perfomance Maybe I was not clear as I should be but here is an example in Firebird: select something,anotherthing,(select sum(thirdthing) from second b where b.something = a.something) total from a where (select sum(thirdthing) from second b where b.something = a.something) > 10 tray sentence: select a.someting, a.anotherthing, b.total from first a inner join ( select someting,sum(thirdhing) as total from second group by someting ) b on a.someting=b.someting where b.total>10
