On Thu, 19 Aug 2021, Rob Sargent wrote:
> sorry, wasn’t clear: person_nbr, next_contact
> On the premise that there can only be one next date.
Rob,
I wasn't sufficiently clear. The contacts table has a row for each
(person_nbr, contact_date). For each row there's also either a next_contact
date or that column is null (e.g., pandemic-related no longer at that
company).
Regards,
Rich