Hi everyone,
I am creating the report program which fetches the duplicate records or fraud records.
Consider PERNR(Personnel ID ) and SSN(Social Security Number) are the fields that is present in the table XXXXXX.
One SSN number can have only one PERNR(which is a unique ID). But if a SSN field value has more than one PERNR value then I have to send that particular details as the fraud record.
So the table XXXXXX may have more SSN number and a particular SSN number may have different PERNRS. I want to send those details as the duplicate or fraud records in the report output if a single SSN has more PERNRS.
Help me in making this output .Thanks in advance.