Removing records from a query

[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

 

[Ken Snell [MVP]]

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

 

[Tony]

Ken,

That was super quick. Worked a treat.
Thanks for your help

Tony