[teknomage1]

SELECT Visitor.FirstName Visitor.LastName FROM Visitor, Attendance WHERE Visitor.ID = Attendance.Visitor_ID AND Attendance.Date = 2004-10-12;

Would get all the visitors who DID attend on a given date. I'm not sure if you can negate that.