SHPORA.net :: PDA

Login:
регистрация
Main
FAQ
гуманитарные науки
естественные науки
математические науки
технические науки
Search:
Title: | Body:

Сформировать списки студентов, у которых в заданный учебный период проводит занятия заданный преподаватель. В отчете указать ФИО студента, название учебной группы, название дисциплины




Select t_student.fio_student, t_institut.sec_name as inst, t_spec.sec_name as spec, t_specs.sec_name as specs, t_formlearn.sec_name as formlearn,

t_learngroup.kurs, t_learngroup.group, t_disc.full_name as disc

From t_lesson

Inner Join t_disc On t_disc.id_disc=t_lesson.id_disc

Inner Join t_learngroup On t_learngroup.id_learngroup=t_lesson.id_learngroup

Inner Join t_student On t_learngroup.id_learngroup=t_student.id_learngroup

Inner Join t_institut On t_learngroup.id_institut=t_institut.id_institut

Inner Join t_spec On t_learngroup.id_spec=t_spec.id_spec

Inner Join t_specs On t_learngroup.id_specs=t_specs.id_specs

Inner Join t_formlearn On t_learngroup.id_formlearn=t_formlearn.id_formlearn

Where t_lesson.id_lector=1 and t_lesson.lesson_begin>'2007-01-01 9:00:00' and t_lesson.lesson_end<'2008-06-01 15:00:00'

Group By t_institut.sec_name, t_spec.sec_name, t_specs.sec_name, t_formlearn.sec_name, t_learngroup.kurs, t_learngroup.group, t_disc.full_name, t_student.fio_student