On Wed, 13 Feb 2019, Adrian Klaver wrote:
> The LEFT JOIN. There are rows in people for which there no records coming
> from the sub-select on activities, so the row is 'padded' with NULL values
> for the missing data.
Adrian,
I assume it's the inner left join. I'll trace what's happening at each step
and learn where to specify no nulls.
Thanks,
Rich