Re: Subquery to select max(date) value

On Wed, Feb 13, 2019, at 9:06 AM, Rich Shepard wrote:
> On Wed, 13 Feb 2019, Adrian Klaver wrote:
>
> > Should have been clearer in my previous post, you can get rid of the nulls
> > by filtering out the entire row.
>
> Adrian,
>
> Thank you. I'm rebuilding the statement from the inside out (which helps me
> learn more SQL in the process). For example,
>
> select * from activities where next_contact is not null and
> next_contact <= 'today' and next_contact > '2018-12-31';
>
> works as written. This suggests that it's the placement within the two joins
> that needs correcting. Now I'll add the two joined tables one at a time and
> learn how to structure the whole statement.

It will work if you use it to filter after the joins are done.

>
> Best regards,
>
> Rich
>
>
>