By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
21 rows affected
| rpid | partyid | partyname | spid | subparty |
|---|---|---|---|---|
| 38 | 43 | UC AM | 14 | CIDS |
| 38 | 44 | CIDW | 15 | DTL |
| 38 | 45 | null | 16 | CRTS |
| 38 | 45 | null | 17 | VIVAR |
| 38 | 46 | KIN TECH | 18 | CT INC |
| 38 | 47 | MAIN RP | 19 | AMC INC |
| 38 | 47 | MAIN RP | 20 | YIBG |