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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement