Subject Re: [firebird-support] Request new feature - better perfomance
Author Djordje Radovanovic
Post date 2014-10-20T07:37:03Z
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
 
Sent: Monday, October 20, 2014 6:37 AM
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