Saturday, June 28, 2014

Display total qty sold of each item of each store

Hi,


I have two tables:


table 1 - ItemMaster:

-
Item#



table 2 - ItemMovement

-
Store#

- Item#

- QtySold


In order to generate a table showing the totals of each item been sold at each store, could you teach me how to generate this kind of SQL query in order to display a table like the example below?



Thanks you.



No comments:

Post a Comment