On Thu, 19 Aug 2021, Rob Sargent wrote:
> Did you try David J’s suggestion? or maybe
Rob,
Yes.
> select person_nbr, max(next_contact) group by person_nbr where
> next_contact < now();
> A table with person_nbr (pk), next_contact would make this much easier.
> Seems to me a person can only have one next-contact? (as opposed to all
> future_contact)
The peoples table has person_nbr as the PK. The contacts table has multiple
rows for all contacts with that person_nbr. The contacts table has a
multicolum PK: person_nbr and contact_date as there is only one contact on
any given day for that person.
HTH,
Rich