Use DateAdd and other functions to add or subtract intervals of time from date values. Try Microsoft Edge A fast and secure. Add to or subtract from date and time. Feb 17, 2004 Minus in Access. Discussion in 'Microsoft Access Queries' started by Guest. Access does not support a MINUS. 'Running Microsoft Access 2000' 'SQL Queries.

INTERSECT is NOT an INNER JOIN. They're different. An INNER JOIN will give you duplicate rows in cases where INTERSECT WILL not. You can get equivalent results by: SELECT DISTINCT a.* FROM a INNER JOIN b on a.PK = b.PK Note that PK must be the primary key column or columns. If there is no PK on the table (BAD!), you must write it like so: SELECT DISTINCT a.* FROM a INNER JOIN b ON a.Col1 = b.Col1 AND a.Col2 = b.Col2 AND a. Ayiti The Cost Of Life Hacked there. Col3 = b.Col3.

With MINUS, you can do the same thing, but with a LEFT JOIN, and a WHERE condition checking for null on one of table b's non-nullable columns (preferably the primary key). SELECT DISTINCT a.* FROM a LEFT JOIN b on a.PK = b.PK WHERE b.PK IS NULL That should do it.