I have three tables that I am using to track who attends meetings on a particular date. When a member attends the meeting, an entry to made into the attendance column:
people - person_ID, lname, fname
date - date_id, date
attendance - attendance_ID, person_ID (FK), date_ID (FK)
How would I show who did not show up for the meeting on a particular date? I've been trying to figure this out for 2 day and have not been able to figure it out. Any suggestions would be appreciated. Thanks.
