How can I implement SQL INTERSECT and MINUS operations in MS Access

by

INTERSECT is an inner join. MINUS is an outer join, where you choose only the records that don’t exist in the other table.

INTERSECT

select distinct
  a.*
from
  a
  inner join b on a.id = b.id

MINUS

select distinct
  a.*
from
  a
  left outer join b on a.id = b.id
where
  b.id is null

If you edit your original question and post some sample data then an example can be given.

EDIT: Forgot to add in the distinct to the queries.

More Related Contents:

  1. Address standardization within a database
  2. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  3. can we list all tables in msaccess database using sql?
  4. Lightweight SQL database which doesn’t require installation [closed]
  5. SQL: Using NULL values vs. default values
  6. SQL Data models
  7. SQL multiple join statement
  8. How to randomly select rows in SQL?
  9. What’s the difference between TRUNCATE and DELETE in SQL
  10. SQL best practice to deal with default sort order
  11. How can I get column names from a table in Oracle?
  12. single fixed table with multiple columns vs flexible abstract tables
  13. How can I send email from PostgreSQL trigger?
  14. How to design a database for User Defined Fields?
  15. How to delete Duplicates in MySQL table
  16. [] brackets in sql statements
  17. Normalization in plain English
  18. Row numbers in query result using Microsoft Access
  19. Core Data Performance with Single Parent Entity
  20. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  21. Why does VARCHAR need length specification?
  22. Access – compare two tables and update or insert data in first table
  23. How to Optimize Queries in a Database – The Basics
  24. “You tried to execute a query that does not include the specified aggregate function”
  25. Know relationships between all the tables of database in SQL Server
  26. Bulk/batch update/upsert in PostgreSQL
  27. How to populate calendar table in Oracle?
  28. Postgres Error: More than one row returned by a subquery used as an expression
  29. Does ‘Select’ always order by primary key?
  30. How do I create and query linked database servers in SQL Server?

Leave a Comment