>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
Try using a Subquery
SELECT * FROM A WHERE Id NOT IN ( SELECT DISTINCT Id FROM B)