Subject Re: [firebird-support] Efficient subselects
Author Marcin Bury
Josef

W dniu 18.04.2014 11:28, Josef KokeŇ° pisze:
>> I would consider the this second option, but I would change the join:
>>
>> SELECT ...
>> FROM DETAIL
>> LEFT JOIN MASTER
>>
>> Check on your real structure and data if it helps
>
> Hi!
>
> Unfortunately, this is not applicable to my case, as I do have MASTERs
> which have no DETAIL (yet).
>

Did you consider using selectable EXECUTE BLOCK, where you iterate
master table with FOR SELECT statement and get the aggregate values from
DETAIL for each MASTER record?

Again it might not work in your real life scenario (WHERE conditions, etc.)

Marcin