By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | NO | DIA |
|---|---|---|
| 20210101 | A01 | 100 |
| 20210101 | A02 | 200 |
| 20210102 | A01 | 100 |
| 20210103 | A01 | 100 |
| 20210103 | A01 | 100 |
| ID | NO | DIA |
|---|---|---|
| 20210102 | X01 | 100 |
| 20210102 | X02 | 150 |
| ID | NO | DIA |
|---|---|---|
| 20210101 | A01 | 100 |
| 20210101 | A02 | 200 |
| 20210102 | X01 | 100 |
| 20210102 | X02 | 150 |
| 20210103 | A01 | 100 |
| 20210103 | A01 | 100 |