All,

I have 2 tables that store a few number of records, A and B. A is a superset of B. For that, I need to perform a SQL Select to get the compliment of B.

Examples, I have 10 records in A but 4 records in B. I need to display the rest of the 6 records which is not in B. I've tried using codes such as..

SELECT * FROM A JOIN B ON Field_A!=Field_B

However, it contains duplicate records because it searches from one record to another.

Any idea for this? Or perhaps better way for not using SQL SELECT?

Gan