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;
       GROUP BY 1,2;
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