SHPORA.net :: PDA

[ Back ]

Select distinct t_lector.fio_lector as fio, t_office.full_name as office

from wasteland.t_lector t_lector

inner join wasteland.t_office t_office on t_lector.id_office = t_office.id_office

inner join wasteland.t_lesson t_lesson on t_lector.id_lector = t_lesson.id_lector



inner join wasteland.t_disc t_disc on t_lesson.id_disc = t_disc.id_disc and t_disc.name = 'бд'

inner join wasteland.t_exercise t_exercise on t_lesson.id_lesson = t_exercise.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_cenz.id_student = t_student.id_student and t_student.id_learngroup = 2

inner join wasteland.t_learngroup t_learngroup on t_student.id_learngroup = t_learngroup.id_learngroup and t_learngroup.learn_yaer = '2006-2007'



для дисциплины бд, учебной группы с идф 2 и учебным год 2006-2007