By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ITEM_SR | CP_ITEM_NO | C_SBS |
|---|---|---|
| 10 | A0001 | N |
| 11 | B0001 | Y |
| 12 | C0001 | Y |
| 20 | D0001 | N |
| 30 | E0001 | Y |
| 40 | F0001 | Y |
| 50 | G0001 | N |
| 51 | H0001 | N |
| 61 | I0001 | N |
| 70 | J0001 | N |
| 71 | K0001 | Y |
| 72 | L0001 | N |
| 110 | A0001 | N |
| 111 | B0001 | Y |
| 112 | C0001 | Y |
| 210 | A0001 | N |
| 211 | B0002 | Y |
| 212 | C0002 | Y |
| BASE_ITEM_NO | SBS_ITEM_NO |
|---|---|
| A0001 | B0001 |
| A0001 | B0002 |
| A0001 | C0001 |
| A0001 | C0002 |
| D0001 | E0001 |
| D0001 | F0001 |
| J0001 | K0001 |