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
