SHPORA.net :: PDA

[ Back ]

Select t_student.fio_student

From t_formlearn

Inner Join t_learngroup On t_formlearn.id_formlearn=t_learngroup.id_formlearn

Inner Join t_student On t_learngroup.id_learngroup=t_student.id_learngroup

Where t_formlearn.id_formlearn=1 and t_learngroup.learn_year='2007-2008'

Order By t_student.fio_student