On 2/13/19 7:37 AM, Rich Shepard wrote:
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.
Should have been clearer in my previous post, you can get rid of the
nulls by filtering out the entire row.
Thanks,
Rich
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
