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=?