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