select ;
	aspirant_card.First_name, ;
	aspirant_card.Second_name, ;
	aspirant_card.Last_name, ;
	aspirant_card.Data_priema, ;
	nvl(nauchnye_rukov.last_name, space(10)) as last_name, ;
	aspirant_card.god_obucheniya , ;
	aspirant_card.zdobuvach, ;
	nauchnye_napravl.nazvanie, ;
	specialnost.nazvanye ;
from aspirant_card ;
left join nauchnye_rukov on aspirant_card.id_rukovoditel = nauchnye_rukov.id_ruk ;
into cursor aa

select ;
	aspirant_card.First_name, ;
	aspirant_card.Second_name, ;
	aspirant_card.Last_name, ;
	aspirant_card.Data_priema, ;
	nvl(nauchnye_rukov.last_name, space(10)) as rukov_last_name, ;
	aspirant_card.god_obucheniya , ;
	aspirant_card.zdobuvach, ;
	nauchnye_napravl.nazvanie as napravl_nazvanie, ;
	specialnost.nazvanye as specialnost_nazvanye;
from aspirant_card ;
inner join nauchnye_napravl on nauchnye_napravl.id = aspirant_card.id_nauch_napr ;
inner join specialnost on specialnost.id = aspirant_card.id_spec ;
left join nauchnye_rukov on nauchnye_rukov.id_ruk = aspirant_card.id_rukovoditel ;
into cursor aa