By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
date | invoice_no | product_id | purchase_quantity | price |
---|---|---|---|---|
2021-01-01 10:00:00 | p-101 | A-1 | 100 | 100 |
2021-01-02 11:00:00 | p-102 | A-1 | 90 | 90 |
2021-01-03 12:00:00 | p-103 | A-1 | 200 | 200 |
2021-01-04 13:00:00 | p-104 | A-1 | 250 | 250 |
date | invoice_no | product_id | sales_return_quantity | price |
---|---|---|---|---|
2021-01-01 10:00:00 | r-101 | A-1 | 10 | 10 |
2021-01-04 13:00:00 | r-104 | A-1 | 25 | 25 |
date | invoice_no | product_id | purchase_quantity | sales_return_quantity | total |
---|---|---|---|---|---|
2021-01-01 10:00:00 | p-101 | A-1 | 100 | null | 100 |
2021-01-01 10:00:00 | r-101 | A-1 | null | 10 | 110 |
2021-01-02 11:00:00 | p-102 | A-1 | 90 | null | 200 |
2021-01-03 12:00:00 | p-103 | A-1 | 200 | null | 400 |
2021-01-04 13:00:00 | p-104 | A-1 | 250 | null | 650 |
2021-01-04 13:00:00 | r-104 | A-1 | null | 25 | 675 |