By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| RecordType | SequenceNumber | NumberOfItems | TicketHeaderKey | UnitID |
|---|---|---|---|---|
| P | 1 | 3 | ; | 1 |
| P | 2 | 1 | ; | 1 |
| P | 3 | 2 | ; | 1 |
| RecordType | SequenceNumber | IDMasterTable | TicketHeaderKey | UnitID |
|---|---|---|---|---|
| I | 19900 | 1 | FA | 19900 |
| I | 3000 | 1 | BK | 3000 |
| I | 0 | 1 | BK | 0 |
| I | 19900 | 2 | FA | 19900 |
| I | 19900 | 3 | FA | 19900 |
| I | 3000 | 3 | BK | 3000 |
Warning: Null value is eliminated by an aggregate or other SET operation.