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
