By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
單號 | 金額 |
---|---|
i001 | 100 |
i002 | 200 |
i003 | 300 |
o123 | 333 |
o223 | 444 |
o323 | 555 |
單號 | 收入金額 | 支出金額 |
---|---|---|
i001 | 100 | 0 |
i002 | 200 | 0 |
i003 | 300 | 0 |
o123 | 0 | 333 |
o223 | 0 | 444 |
o323 | 0 | 555 |