Quick Links

Re: Subquery to select max(date) value

From:	Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To:	"pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject:	Re: Subquery to select max(date) value
Date:	2019-02-13 15:37:44
Message-ID:	alpine.LNX.2.20.1902130736190.10544@salmo.appl-ecosys.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

Re: Subquery to select max(date) value at 2019-02-13 14:48:10 from Adrian Klaver

Responses

Re: Subquery to select max(date) value at 2019-02-13 15:46:42 from Adrian Klaver
Re: Subquery to select max(date) value at 2019-02-13 16:01:33 from Adrian Klaver
Re: Subquery to select max(date) value at 2019-02-13 20:25:55 from Adrian Klaver

Browse pgsql-general by date

	From	Date	Subject
Next Message	Adrian Klaver	2019-02-13 15:46:42	Re: Subquery to select max(date) value
Previous Message	Adrian Klaver	2019-02-13 14:48:10	Re: Subquery to select max(date) value