By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
dtlno | dtlqty |
---|---|
A | 5 |
A | 10 |
B | 1 |
B | 3 |
c | 10 |
D | 55 |
brdno | brdamount |
---|---|
A | 0 |
B | 0 |
C | 0 |
X | 0 |
brdno | brdamount |
---|---|
A | 15 |
B | 4 |
C | 10 |
X | 0 |
dtlno | dtlqty |
---|---|
A | 5 |
A | 10 |
B | 1 |
B | 3 |
c | 10 |
D | 55 |
brdno | brdamount |
---|---|
A | 0 |
B | 0 |
C | 0 |
X | 0 |
brdno | brdamount |
---|---|
A | 15 |
B | 4 |
C | 10 |
X | 0 |