Trying to do a find where 2 fields are equal across records
I am trying to do a find where records have two fields that are equal. I have a transaction file where I have a unique customer ID field and a date of transaction field. I want to find all the records where for each record those two fields were matched in another record.
Record 1: ID 45 Date 11/11/12
Record 2: ID 45 Date 11/11/12