I'm using the standard 'In(Select...' to find records with duplicate field values. Now that I have the list, I'd like to view only those where all fields in the duplicate records are not equal.
For instance:
a b c d - will show
a b c x
a b c d - will not show
a b c d
I've tried everything I can think of. Unfortunately, I'm not very SQL-friendly, and the syntax of the statements to make use of Count is apparently beyond me.
For instance:
a b c d - will show
a b c x
a b c d - will not show
a b c d
I've tried everything I can think of. Unfortunately, I'm not very SQL-friendly, and the syntax of the statements to make use of Count is apparently beyond me.