Cacher is the code snippet organizer for pro developers

SELECT ZG.SU_KENNZAHL ,ZG.SJ_SCHULJAHR, ZG.SG_KENNZAHL, ZG.ZG_ID, ZG.KL_ID, ZG.ZG_ART,
       ZG.ZG_STT_ID, ZG.ZG_DATUM, SCH.SG_VORNAME1, SCH.SG_FAMNAME, SCH.SG_GEBURTDAT
FROM ZEUGNIS ZG, SCHUELER SCH 
WHERE SU_KENNZAHL = 922015
AND ZG_ART = 'Jahreszeugnis' 
AND ZG_EDITKZ = 0 
AND ZG_NOPRINTKZ = 0 
AND ZG_DATUM >= '01.09.2012'
AND SCH.SG_KENNZAHL = ZG.SG_KENNZAHL
OR SU_KENNZAHL = 922015
AND ZG_ART = 'Jahres- und Abschlusszeugnis' 
AND ZG_EDITKZ = 0 
AND ZG_NOPRINTKZ = 0 
AND ZG_DATUM >= '01.09.2012'
AND SCH.SG_KENNZAHL = ZG.SG_KENNZAHL;