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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Ravi K KashyapPosted Jun 27, 2011, 1:36 AM
USE THIS
SELECT
itemname,partno,unit,qty1+qty2 AS [TOTAL QUANTITY],price FROM ITEM WHERE ITEMCODE = '###'Suthish NairPosted Jun 27, 2011, 8:38 AM
Jiteendra SampathiraoPosted Jun 27, 2011, 1:57 AM
Sandeep ShekhawatPosted Jun 27, 2011, 1:32 AM