By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| TransID | DocNum |
|---|---|
| 4 | 0000001 |
| 5 | 0000002 |
| 5 | 0000002 |
| 6 | 0000003 |
| 6 | 0000003 |
| 7 | 0000004 |
| 7 | 0000004 |
| DocNum |
|---|
| 0000004 |
| TransID | DocNum |
|---|---|
| 4 | 0000001 |
| 5 | 0000002 |
| 5 | 0000002 |
| 6 | 0000003 |
| 6 | 0000003 |
| 7 | 0000004 |
| 7 | 0000004 |
| DocNum |
|---|
| 0000004 |