> SELECT Etats.nPoscat, ; > Etats.ccat_physiq ,; > Etats.ntype , ; > COUNT( DatesFiltred.ddate ) Ncat, ; > Etats.ltransfert ; > FROM FORCE DatesFiltred JOIN Etats ; > ON Etats.nPoscat = DatesFiltred.nPoscat AND Etats.ntype=DatesFiltred.ntype ; > GROUP BY ltransfert , Etats.ntype , Etats.nPoscat ; && IMPLICIT ORDER ON VFP > INTO CURSOR Sum_Categ_per_periode >>
> SELECT Etats.nPoscat, ; > Etats.ccat_physiq ,; > Etats.ntype , ; > COUNT( DatesFiltred.ddate ) Ncat, ; > Etats.ltransfert ; > FROM DatesFiltred JOIN FORCE Etats ; > ON Etats.nPoscat = DatesFiltred.nPoscat AND Etats.ntype=DatesFiltred.ntype ; > GROUP BY ltransfert , Etats.ntype , Etats.nPoscat ; && IMPLICIT ORDER ON VFP > INTO CURSOR Sum_Categ_per_periode >>
>SELECT SUM(Ncat) FROM Sum_Categ >and >SELECT SUM(Ncat) FROM Sum_Categ_per_periode >