Subject Re: [firebird-support] Why this SQL is correct?
Author Dimitry Sibiryakov
14.10.2019 11:47, ma_golyo@... [firebird-support] wrote:
> In the subselect p.proj_id should not be accepted - group does not contains it, and has no
> aggregate on it. What value the engine choose when it runs, and why?

Current one. The subquery is executed for each record of master result set BEFORE grouping.