By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 12 Duplicates: 0 Warnings: 0
Records: 5 Duplicates: 0 Warnings: 0
| patient_id | session_id |
|---|---|
| Pat1 | Sess1_P1 |
| Pat1 | Sess1_P1 |
| Pat1 | Sess1_P1 |
| Pat1 | Sess2_P1 |
| Pat1 | Sess2_P1 |
| Pat1 | Sess2_P1 |
| Pat1 | Sess4_P1 |
| Pat1 | Sess4_P1 |
| Pat2 | Sess1_P2 |
| Pat2 | Sess1_P2 |
| Pat2 | Sess2_P2 |
| Pat2 | Sess2_P2 |
| patient_id | session_id |
|---|---|
| Pat1 | Sess1_P1 |
| Pat1 | Sess2_P1 |
| Pat1 | Sess3_P1 |
| Pat2 | Sess1_P2 |
| Pat2 | Sess2_P2 |
| session_id | session_id |
|---|---|
| Sess1_P1 | Sess1_P1 |
| Sess2_P1 | Sess2_P1 |
| Sess4_P1 | null |
| Sess1_P2 | Sess1_P2 |
| Sess2_P2 | Sess2_P2 |
| null | Sess3_P1 |