I am working on a query that will compare these two data sets and only pull the data that is in the data set one and not in the other. My issue is that Jet SQL in access does not recognize the except clause. Is there an easy substitute for this issue.
SELECT List1.[Building ID], List1.[Building Name], List1.Address, List1.City, List1.[State Code], List1.[Postal Code], List1.[Property Ownership Status], List1.[Property Total RSF], List1.[Record Type], List1.[Property Type], List1.[Facility Management Provider], List1.[Facility Manager], List1.[RD RFM]
FROM List1
EXCEPT
SELECT List2.[Building ID], List2.[Building Name], List2.Address, List2.City, List2.[State Code], List2.[Postal Code], List2.[Property Ownership Status], List2.[Property Total RSF], List2.[Record Type], List2.[Property Type], List2.[Facility Management Provider], List2.[Facility Manager], List2.[RD RFM]
FROM List2
