469,955 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

i have two tables production.product(and sales table and i want to get the total unit

Production.producttable(productid, productcategory, modifieddate and sales table( salesorderid, productid, ,quantity,unitprice,modifieddate,orderdate) so i want to get the total amount of unit solid from this two table. How can i write my query?
Oct 29 '20 #1
1 2913
Banfa
9,065 Expert Mod 8TB
Expand|Select|Wrap|Line Numbers
  1. SELECT productid, SUM(quantity) FROM sales GROUP BY productid
Oct 30 '20 #2

Post your reply

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

Similar topics

7 posts views Thread by Emin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.