1 2 3 4 5
| SELECT Max(OperationCasing.DateSaisie) AS fin, Min(OperationCasing.DateSaisie) AS debut, Commande.diametre, Commande.epaisseur, Commande.TypeDeFiletage, Commande.grade, Commande.SpecClient, Commande.NomClient, Commande.peinture, Commande.phosphatation, Commande.GraisseManuel, Sum(OperationCasing.BoutsBons) AS SommeDeBoutsBons, Commande.CoefCasing, Commande.CoefFiletage2002, Sum(OperationCasing.TempsPresence) AS SommeDeTempsPresence, Count(*) AS CompteDePoste
FROM OperationCasing INNER JOIN Commande ON OperationCasing.NumCommande = Commande.NumCommande
WHERE (((OperationCasing.NumCommande)='000000/00') AND ((OperationCasing.NomPoste) In ('HT4822','HT4821','ST4420','ST4421')))
GROUP BY Commande.diametre, Commande.epaisseur, Commande.TypeDeFiletage, Commande.grade, Commande.SpecClient, Commande.NomClient, Commande.peinture, Commande.phosphatation, Commande.GraisseManuel, Commande.CoefCasing, Commande.CoefFiletage2002
Having Count(*)=(SELECT Distinct DateSaisie,Poste From operationCasing Where NomPoste IN ('HT4822','HT4821','ST4420','ST4421')); |
Partager