Translate Oracle SQL syntax to Access 2007 SQL syntax
Posted on 2013-10-28
Since Access 2007 does not use With... As or MINUS, can the following query be translated into Access 2007 SQL language?
I am running an exception report for staff sign in dates, showing the names & dates of the staff who did not sign in during a certain date range (i.e., 10/1/2013-10/15/2013).
With distinct_users as (
select distinct lastname from aps.facultydates
select b.lastname, a.visitstartdate from aps.facultydates a,distinct_users b
select lastname, visitstartdate from aps.facultydates