select alumno.alumno_apellido, alumno.alumno_nombre,
(select infxmateria.ixm_nota from infxmateria where infxmateria.ixm_idmateria = 1 and ixm_idciclolectivo = 2008 and ixm_idalumno = alumno.alumno_idalumno and ixm_idinforme = 1) as materia.materia_descripcion
from alumno join alumxcurso on (alumno.alumno_idalumno =
alumxcurso.axc_idalumno)where alumxcurso.axc_idcurso = 1 and alumxcurso.axc_iddivision = 'A' and alumxcurso.axc_idciclolectivo =
2008 order by alumno.alumno_apellido