Re: Subquery to select max(date) value

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

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