By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
lagr_number | ltran_number |
---|---|
K000001 | V000001 |
K000001 | V000004 |
K000001 | V000005 |
K000002 | V000001 |
K000003 | V000002 |
K000003 | V000003 |
K000004 | V000005 |
K000005 | V000007 |
K000005 | V000008 |
K000006 | V000009 |
K000007 | V000009 |
lagr_number | grp |
---|---|
K000001 | 1 |
K000002 | 1 |
K000004 | 1 |
K000003 | 2 |
K000005 | 3 |
K000006 | 4 |
K000007 | 4 |