Reverse of UNION

  • Thread starter Thread starter XMan
  • Start date Start date
X

XMan

Instead of combining results of two queries, is there a way to get the
difference between them? TIA.
 
XMan said:
Instead of combining results of two queries, is there a way to get the
difference between them?
Click to expand...

Depends on what you mean by "difference". Usually this
means all the records in tableA that are not in tableB. If
that's what you want, then use a frustrated Join type query:

SELECT tableA.*
FROM tableA LEFT JOIN tableB
ON tableA.fielda = tableB.fieldb
WHERE tableb.fieldb IS NULL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use the results of a query for a different query. 1
Query is too complex 5
UNION QUERY.. 3
combining results from two seperate forms 3
Excel Excel spreadsheets opening at top instead of bottom. 4
Union query 2
union query with "unique" and "is not null" values 1
Can a Add a String to a Union Query? 4

Back
Top