By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
A001 | A002 | A003 |
---|---|---|
1AA | 1111 | null |
1AA | 1112 | |
2AA | 1111 | |
2AA | 1112 | XX55555555 |
3AA | 1110 |
B001 |
---|
AB00000000 |
5 rows affected
A001 | A002 | A003 |
---|---|---|
1AA | 1111 | AB00000000 |
1AA | 1112 | AB00000001 |
2AA | 1111 | AB00000002 |
2AA | 1112 | XX55555555 |
3AA | 1110 | AB00000003 |
B001 |
---|
AB00000004 |