Exclude data points where fields are equal

[jysupert]

I am trying to exclude data from cells that have same value in two separate fields.

Used to correct errors in multiple process chain. Ideally only values showing should be the errors. Can this be written into a query?



No. F2 F3
1 X1 Y1
2 X1 X1

No.1 would return value as they do not match


Thanks in advance

[June7]

Maybe:

SELECT * FROM tablename WHERE F2<>F3;