>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

Bernhart,
Instead of a union can't you write it as single SQL using or?

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

Cetin