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 |
A001 | A002 | A003NEW |
---|---|---|
1AA | 1111 | AB00000000 |
1AA | 1112 | AB00000001 |
2AA | 1111 | AB00000002 |
3AA | 1110 | AB00000003 |
A001 | A002 | A003 | A001 | A002 | A003NEW |
---|---|---|---|---|---|
1AA | 1111 | null | 1AA | 1111 | AB00000000 |
1AA | 1112 | 1AA | 1112 | AB00000001 | |
2AA | 1111 | 2AA | 1111 | AB00000002 | |
3AA | 1110 | 3AA | 1110 | AB00000003 |