Thanks for the subquery tips. It works perfectly. Just that it ended up with a very long code.

Gan



>>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)