Here is the sql syntax for the query that is failing:
SELECT icitem01.item, icitem01.cntcode, [BOM Top Level Cycle Count
Codes].CycleCntCode
FROM icitem01 INNER JOIN [BOM Top Level Cycle Count Codes] ON icitem01.item
= [BOM Top Level Cycle Count Codes].PARTNO
WHERE (((icitem01.cntcode)<>[CycleCntCode]));
The problem is that when it runs, it return 2 or 3 different rows everytime
it runs and it should not return any rows at all. The reason it shouldn't
return anything is because the two values that are used in the where clause
are both equal to each other in every row of the table that I'm using.
Please help me in any way you can.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only