SELECT lic.lickurz as 'Lizenz-ID',lic.licname as 'Lizenzname',lic.licdesc as 'Beschreibung', att.ATTNAME as 'Attribut', att.ATTVALUE as 'Wert', atyp.ATTVALUE as 'Attribut-Beschreibung'

  FROM BOSWLIC lic

    LEFT OUTER JOIN CCATT att on att.ATTARCHTYP='SWLICATT' and att.ATTPARTYPE='BOSWLIC' and att.ATTPARKURZ=lic.lickurz

      LEFT OUTER JOIN CCATT atyp on atyp.ATTARCHTYP='SWLICATTTYP' and atyp.ATTPARTYPE='SWLICATT' and atyp.ATTPARKURZ='ALLSWLICATT' and atyp.ATTNAME=att.ATTNAME