select JAHR as "Jahr", MONAT as "Monat", resm.ENV as "Umgebung", rt.RWDESC as "Ressourcen-Type", 

             resm.AMOUNT as "Menge" 

  from CCVDCRESM resm 

     left outer join CCRW rt on rt.RWTYP='DCRTYP' and rt.RWPARENT='DCR' and rt.RWNAME=resm.RESTYPE 

  where jahr=? and ENV=? and RESTYPE=?