Postgres Pro
Downloads
Home   >   mailing lists

Re: Subquery to select max(date) value - Mailing list pgsql-general

From Rich Shepard
Subject Re: Subquery to select max(date) value
Date
Msg-id alpine.LNX.2.20.1902130736190.10544@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Subquery to select max(date) value  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Subquery to select max(date) value  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Subquery to select max(date) value  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Subquery to select max(date) value  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Adrian Klaver
Date:
Subject: Re: Subquery to select max(date) value