What is the opposite to an "Union All" clause in MS Access?
Posted on 2011-02-15
I have two queries with the same fields. The first one returns 1000 records; the second one, 100 records whose Id's intersect with some of the first query. What I want to do is to perform a query that shows the records of the first query MINUS the ones of the second query. In fact, what I'm looking for here is the opposition of an Union All clause.
I tried this ("Not In" clause) before, but it didn't return any record. Weirdly enough, an "In" clause works fine, nut not a "Not In" clause.
SELECT [Équipement total].MODEL_NO
FROM [Équipement total]
where [Équipement total].MODEL_NO
(SELECT [Équipement à exclure].MODEL_NO
FROM [Équipement à exclure])
order by MODEL_NO
Would anyone have a solution to this simple problem?