add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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