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.name = 'бд'



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

Inner join wasteland.t_typeexercise t_typeexercise On t_typeexercise.id_typeexercise=t_exercise.id_typeexercise and t_typeexercise.name_type = 'Самостоятельная'

Inner Join wasteland.t_cenz t_cenz On t_cenz.id_exercise=t_exercise.id_exercise and t_cenz.cenz > 2

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



where 0= (select count(1)from t_learngroup, t_disc

Inner Join wasteland.t_lesson t_lesson On t_lesson.id_disc=t_disc.id_disc and t_disc.name = 'бд'



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

Inner join wasteland.t_typeexercise t_typeexercise On t_typeexercise.id_typeexercise=t_exercise.id_typeexercise and t_typeexercise.name_type = 'Самостоятельная'

Inner Join wasteland.t_cenz t_cenz On t_cenz.id_exercise=t_exercise.id_exercise and t_cenz.cenz = 2

where id_student=t_student.id_student and t_learngroup.learn_yaer = '2006-2007' )