Hi all,


This sql command give " Sql group by is invalid or missing "....

 SET ENGINEBEHAVIOR 80

SELECT E.iid AS 'iempl' , ;
    NVL( P.iPlanPauseID , 0 ) AS 'plpid' ,;
    SUM( H.n120 + H.n100 ) AS "nsum";
    FROM Employee E;
    INNER JOIN Horaire H  ON  E.iid = H.iemployeeid ;
    INNER JOIN PAUSE P ON P.iid = H.cpauseid  ;
    WHERE MONTH(H.ddate) = 2 AND YEAR(H.ddate) =  2005 AND E.iid = 127;
    UNION;
    SELECT E.iid AS 'iempl' , ;
    NVL( P.iPlanPauseID , 0 ) AS 'plpid' ,;
    SUM( H.n120 + H.n100 ) AS "nsum";
    FROM Employee E;
    INNER JOIN Horaire H  ON  E.iid = H.iemployeeid ;
    INNER JOIN PAUSE P ON P.iid = H.cpauseid2  ;
    WHERE MONTH(H.ddate) = 2 AND YEAR(H.ddate) = 2005 AND E.iid = 127;
    GROUP BY 1 , 2 INTO CURSOR Temp

What can i do ?

bernhart