Friday, June 27, 2014

Display total qty of each store of each item

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