sql select problem

[mkinzler]

SQL-Code:

select 
    z.*, f.name
from 
    zeugnis z join faecher f on f.id = z.faecher_id 
where 
    z.id_Schueler =:IdSchueler and z.id_Klasse =:KlassenID;