Hi, I have to retrive records from a table that are not present in another table with the same schema. To do this I have to use the MINUS operator in the query. But I am working with access database and as much I know it doesn't support MINUS operator, is there any other way ? Plz help me as soon as possible
A query like :
SELECT * FROM Table_A
MINUS
SELECT * FROM Table_B;
does not work. Byeee
- Bitan Kr. Kundu

You really need to post this in the Access or the SQL forums.

-PatP