Torna al Thread
SELECT dbo.Vp.[Sap Product code], dbo.Vp.[Sale date], dbo.Vp.[Sale quantity UMB]
SUM dbo.Vp.Sale quantity UMB
FROM dbo.Vp INNER JOIN
dbo.somma ON Vp.Sap Product code=somma.Sap Product code
WHERE [Sap Product code] IN ('16662','16661','16663','16664','17189','17190','17191','17192','17802','17803','17804','17805')
GROUP BY [Sap Product code], [Sale date], [Sale quantity UMB]
HAVING ([Sale date] LIKE '= 102009%')
ORDER BY [Sale date]