Sum of two tables

Shyja Abraham

15y3.4k

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
Accepted answer
you need to have a null check..

select c1.Itemcode ,c1.ItemName
    , (c1.qty + isnull(c2.qty, 0)) qty
    , (c1.value + isnull(c2.value, 0)) value
    from Cashsale c1 left join dbo.Creditsale c2
    on c1.Itemcode = c2.Itemcode
0
15y ago
select csh.Itemcode,csh.itemname ,csh.qty + cst.qty as qty from Cashsale csh left join creditsale cst on csh.itemcode=cst.itemcode
0
Vilas Gite15y ago
HI Shyja
here, nice critical quires for further references...
refer : http://www.1keydata.com/sql/sqlouterjoin.html
----------------------------------------------------------------------------------------------------

If this reply hepls your post…then "MARK AS ANSWER"!
0
Deepthi Aravind15y ago
Try this query,

select CS.ItemCode,CS.ItemName,CS.qty+CR.qty 'Qty',CS.value+CR.value 'Value' from Cashsale CS
left join Creditsale CR
on CS.ItemCode=CR.ItemCode
0