I have two tables. One with People, the other with contacts. I can join the tables via People (PersonID) and Contacts (PersonID) columns.
In the Contacts Table, I have ContactDate.
I want to select all People with not contact within 7 days.
How? I'm getting contacts rows which aren't the most recent rows when I join the tables and do a where clause saying ContactDate > 7 days.
I need the date of my the most recent contact I guess.
But ultimately I only want People returned who have no contact date within 7 days.