Removing records from a query

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,

I have 2 queries A & B.
How do I remove the records produced by query A from query
B, so that query B shows a complete list of records but
less those contained by query A. Both queries use a
primary key field called RefNo.

Hope all this makes sense.

Tony
 
SELECT QueryB.*
FROM QueryB LEFT JOIN
QueryA ON QueryB.RefNo =
QueryA.RefNo
WHERE QueryA.RefNo Is Null;
 
Back
Top