Re: Subquery to select max(date) value

[Rich Shepard]

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