By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
euid | lid | systemcode |
---|---|---|
100 | 1003 | RG |
100 | 1004 | RG |
100 | 1005 | RG |
200 | 1006 | CA |
300 | 1009 | RG |
puid | pid | systemcode | num_matches |
---|---|---|---|
300 | 1008 | RG | 0 |
euid | lid | systemcode |
---|---|---|
100 | 1003 | RG |
100 | 1004 | RG |
100 | 1005 | RG |
200 | 1006 | CA |
300 | 1009 | RG |
puid | pid | systemcode | num_matches |
---|---|---|---|
300 | 1008 | RG | 0 |