4_4!.sql

来自「to study the example of creation of tabl」· SQL 代码 · 共 11 行

--Students KS


select st_surname as LName, left(st_name,1) as FName, left(st_pname,1) as Mname, kurs as Kurs 
	from Person t1 
INNER JOIN Student t2  
ON t1.id_person=t2.id_person 
INNER JOIN Grouppa t3  
ON t2.id_group=t3.id_group 
where left(group_name,2)='KS'