select env.parent as ENV,resa.JAHR as JAHR,resa.KW as KW,'0000' as MONDAY,resa.RESTYPE as RESTYPE,SUM(resa.AMOUNT) as AMOUNT from CCDCRESA resa left outer join CCDCENV env on env.env=resa.env  where env.parent=:ENV and resa.RESTYPE=:RESTYPE group by env.PARENT,resa.RESTYPE,resa.JAHR,resa.KW order by env.PARENT, resa.JAHR, resa.KW asc