Sum of two columns

Jun 27 2011 1:19 AM

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)

Select distinct

SQLite