sorry

try it http://www.Amline.be/Test.txt AND http://www.Amline.be/Test1.txt



>ftp://195.146.205.14/Utilisateurs/Bernhart/
>
>don't accept anonymous access.
>
>Try this:
>
>

>  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
>

>
>without index and with 1 or two index.
>
>post :
>

>SELECT SUM(Ncat) FROM Sum_Categ
>and
>SELECT SUM(Ncat) FROM Sum_Categ_per_periode
>