Сформировать список студентов заданной формы обучения в заданный учебный год
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