1 2 3 4 5 6 7 8 9
| SELECT DocDetail.DocDetailDesignation, DocDetail.DocDetailIdFamille, DocDetail.DocDetailIdArticle, SUM(DocDetail.DocDetailQuantite) AS Total,
DocAdmin.DateEcheance, DocAdmin.IdTournee
FROM DocDetail INNER JOIN
DocAdmin ON DocDetail.NumDocAdmin = DocAdmin.NumeroDocument
WHERE (DocAdmin.DateEcheance = '21/05/2010') AND (DocAdmin.TypeDocument = 'BL')
GROUP BY DocDetail.DocDetailDesignation, DocDetail.DocDetailIdFamille, DocDetail.DocDetailIdArticle, DocAdmin.DateEcheance, DocAdmin.IdTournee
HAVING (DocAdmin.IdTournee = 0) OR
(DocAdmin.IdTournee = 2)
ORDER BY DocDetail.DocDetailIdFamille |
Partager