• Table has names & sign in dates (8/1/2013 thru today).
• I need to determine exceptions within a date range, such as 10/1/2013 thru 10/15/2013--who did not sign in on a certain date within that date range. No record is created if person did not sign in on a certain date.
• Results should return name & date not signed in.
o John Smith, 10/11/2013
o Mary Jones 10/2/2013
• I’ve tried lots of things, obviously incorrect.
Also need to see the query in Oracle SQL and Access 2007 SQL please!