SHPORA.net :: PDA

[ Back ]

SELECT DISTINCT T_STUDENT.FIO

FROM WASTELAND.t_disc AS t_disc

Inner Join wasteland.t_lesson t_lesson On t_lesson.id_disc=t_disc.id_disc and t_disc.id_disc = 1

and t_lesson.begin_lesson >= '2008-10-01 10:00:00.0' and t_lesson.end_lesson <= '2008-12-01 12:00:00.0'

Inner Join wasteland.t_exercise t_exercise On t_exercise.id_lesson=t_lesson.id_lesson

Inner Join wasteland.t_cenz t_cenz On t_cenz.id_exercise=t_exercise.id_exercise

Inner Join wasteland.t_student t_student On t_student.id_student=t_cenz.id_student



where t_student.id_student=t_cenz.id_student

group by (t_student.fio) having min(t_cenz.cenz)<>2;