select us.USVORNAME, us.USFAMILIENNAME, t.PROJECT, t.TASKID, t.TASKNAME, t.PSPCODE, t.FCDATE,

       t.ESTEFFPH,

       (select ROUND(IFNULL(SUM(STUNDEN),0)) from CCILV where USKURZZ=t.TASKRESP and PSP=t.PSPCODE) as SUMME_ISTSTUNDEN,

       t.FCESTEFFPH 

  from CCVTASKFC t

    left outer join CCUS us on us.USKURZZ=t.TASKRESP

 where t.PROJECT='ZPI2017' and t.TASKRESP=?