1 2 3 4 5
| SELECT c.NumCommande, c.diametre, c.epaisseur, c.TypeDeFiletage, c.grade, c.NomClient, c1.NumCommande, c1.diametre, c1.epaisseur, c1.TypeDeFiletage, c1.grade, c1.NomClient
FROM Commande AS c INNER JOIN OperationCasing AS o ON c.NumCommande = o.NumCommande, Commande AS c1 INNER JOIN SupervisionCasing AS s ON c1.NumCommande = s.NumCommande
WHERE (((o.NomPoste) In ('Rec.Agt.Csg')) AND ((o.Poste)='c,Bertaux') AND ((o.DateSaisie) Between #1/1/2006# And #2/1/2006#))
GROUP BY c.NumCommande, c.diametre, c.epaisseur, c.TypeDeFiletage, c.grade, c.NomClient, c1.NumCommande, c1.diametre, c1.epaisseur, c1.TypeDeFiletage, c1.grade, c1.NomClient, s.DateSaisie, s.Poste, s.NomPoste
HAVING (((s.DateSaisie) Between #1/1/2006# And #2/1/2006#) AND ((s.Poste)='c,Bertaux') AND ((s.NomPoste) In ('SupQuaCsg'))); |
Partager