>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.
What type and size are the fields? It may be having problems with leading/trailing spaces depending on the data type of the fields. Also you don't need any parenthesis after the WHERE clause.
Previous
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