SELECT 
crs.serial_crs, 
lvl.serial_lvl, 
sec.serial_set,  
clg.serial_clg,
spt.serial_spt,
scy.serial_scy,
CONCAT(lvl.name_lvl,' ',sec.name_set,' ',clg.name_clg) as name_crs FROM 
course crs 
JOIN level lvl ON crs.serial_lvl = lvl.serial_lvl
JOIN section sec ON crs.serial_set = sec.serial_set
JOIN class_group clg ON crs.serial_clg = clg.serial_clg
JOIN specialty spt ON crs.serial_spt = spt.serial_spt
JOIN school_year scy ON crs.serial_scy = scy.serial_scy
WHERE crs.status_crs = 'ACTIVE'