469,917 Members | 1,683 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

how to get the sum of the fields ...Very URGENT

hi .. iam having a table with six fields which is holding some values.
there are two branches for a company. now they want to see the two branches values at once . that is sum of the stockin,
sum of the stock out etc...

my table is here...
stockin
stockout
stockinhand
openingstock
unitrate
value.

Now i want to get the sum of these two branches
Jun 26 '07 #1
1 978
satane
4
hi,

in ur table there is no feilds to specify the branch like branch id like that.
if there is baranch id then the query is like this......

select sum(stockin) as stockinn,sum(stockout) as stockoutt from stack where branchid=1


othere wise can u send me how u identify two differnt branches.
Jun 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Young Seeker | last post: by
33 posts views Thread by dembla | last post: by
1 post views Thread by alok sengar | last post: by
1 post views Thread by rajesh.us.it.recruiter | last post: by
9 posts views Thread by Peter | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.