I have 2 tables
Cash sale
Itemcode itemname qty price value
A1 apple 2 12 24
B1 orange 1 20 20
C2 pinapple 3 30 90
Credit sale
Itemcode itemname qty price value
A1 apple 3 10 30
B1 orange 2 40 80
I want to display
Itemcode itemname qty value
A1 apple 5 54
B1 orange 3 100
C2 pinapple 3 90
How we write tis query plz help?