4
Reply

Sum of two columns

Shyja Abraham

Shyja Abraham

Jun 27 2011 1:19 AM
2.4k


I have a  table(itemid, itemcode,itemname,unit,partno,qty1,qty2,price) named item

I want to " select itemname,partno,unit,sum(qty1+qty2),price from item where itemcode='###'". but it will not work .plz help?

Answers (4)
Next Recommended Forum