1 2 3 4 5 6 7
| SELECT A.MrqCod, Q.MrqLib,SUM(iif(D.DmvFlg='E',DmvQte,0)) As QteEnt,SUM(iif(D.DmvFlg='E',D.DmvMtn,0)) As ValeurEnt,SUM(iif(D.DmvFlg='R',DmvQte,0)) As QteReint,SUM(iif(D.DmvFlg='R',D.DmvMtn,0)) As ValeurRein,SUM(iif(D.DmvFlg='S',DmvQte,0)) As QteSor,SUM(iif(D.DmvFlg='S',D.DmvMtn,0)) As ValeurSor,MgsInt,MgsIt1,MgsIt2
FROM Mouvement M, Detail_Mouvement D, Marque Q, Reference R, Article A,magasin
WHERE M.MvtNum = D.MvtNum
AND D.RefFou=R.RefFou
AND R.ArtCod=A.ArtCod
AND A.MrqCod=Q.MrqCod
GROUP BY A.MrqCod,Q.MrqLib,MgsInt,MgsIt1,MgsIt2 ORDER BY A.MrqCod |
Partager