select ag.id_alu as CODIGO, ape_per as APELLIDO ,nom_per as NOMBRE ,des_cur as SECCION, apro_alu as ESTADO
from alum_grado ag
inner join  alumcurso ac using(id_alu)
inner join alumno al using(id_alu)
inner join curso c using(cod_cur)
where ag.cod_gra = var01
order by c.cod_cur , ape_per,nom_per
