By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
Name | ID | Account |
---|---|---|
Nicole | 01 | 12345 |
Nicole | 01 | 67890 |
Alexis | 02 | 67890 |
User01 | 01 | 99999 |
User02 | 02 | 99999 |
User02 | 02 | 99999 |
User03 | 03 | 99999 |
Name | ID | Account | Column_A | NumberOfMatches | Column_B | BadID |
---|---|---|---|---|---|---|
Nicole | 01 | 12345 | No | 1 | Nicole (OK) | null |
Alexis | 02 | 67890 | Yes | 2 | Nicole (BAD) | 01 |
User02 | 02 | 99999 | Yes | 4 | User01 (BAD) | 01 |
User03 | 03 | 99999 | Yes | 4 | User01 (BAD) | 01 |