[AccessD] compare two fields

Hello group,

is there a way to compare the values of two fields in one record
Al the records where the values of the two fields don't match (in one record) must be given in the result.

I have done this before, but i can't find the sql.

Thanks

- Pedro Janssen -

Example:

Table1

fieldA    fieldB

012345    012345
456789    456789
234567    034567

result
234567    034567