Select non matching rows
Posted: Fri Oct 15, 2010 6:07 pm
Hey,
How do you do a query that selects non matching rows from a single table by camparing values in one field.
Say two rows had:
FieldName : 5
FieldName : 4
This in a query should be noticed and selected as the two rows have different field values.
Any idea how this is done?
How do you do a query that selects non matching rows from a single table by camparing values in one field.
Say two rows had:
FieldName : 5
FieldName : 4
This in a query should be noticed and selected as the two rows have different field values.
Any idea how this is done?