SHPORA.net :: PDA

[ Back ]

Select t_structdisc.name_part, t_lector.fio_lector, t_disc.full_name

from t_lector

Inner Join t_lesson On t_lector.id_lector=t_lesson.id_lector

Inner Join t_disc On t_disc.id_disc=t_lesson.id_disc

Inner Join t_structdisc On t_structdisc.id_disc=t_disc.id_disc

Where t_disc.id_disc=1 and t_lector.id_lector=1

Order by t_structdisc.name_part