Find value not available in Other Table - MS Access

[MUKESHY12390]

Hi All,

I'm trying to build query to get record which are not available in other table. I know the query it works every other database but not in which I'm using.

SELECT ID from A
Where ID NOT In(Select ID from B)

Is there something to do with the value like any special character in field.

And by using Do loop I can get record but the situation doesn't demand for loop.I need build query only.

Any help would be appreciate.

Thanks,
Mukesh Y

 

[stumac]

Your query looks OK - are the ID fields the same data type?

An alternative approach which I prefer is using an outer join:

SELECT A.ID
FROM A LEFT JOIN B ON A.ID = B.ID
WHERE B.ID Is Null

 

[MUKESHY12390]

thanks a lot.. I will try btw I got the solution.

there was one null field in record which I Update first as "NoComment" then proceed. Everything back to business.

but it seems by using your query i don't have to update stuff.