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


Reply via email to