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.
Best regards,
Rich