SELECT s.nom_sed, j.des_jor, g.des_gra,c.des_cur, a.id_alu, a.nom_per, a.ape_per FROM alumno a
INNER JOIN v_bd.alumcurso ac USING (id_alu)
INNER JOIN v_bd.alum_grado ag USING (id_alu)
INNER JOIN v_bd.curso c USING (cod_cur) 
INNER JOIN v_bd.grado g ON g.cod_gra=c.cod_gra
INNER JOIN v_bd.sede s USING (id_sed)
INNER JOIN v_bd.jornada j USING (id_jor)
WHERE
ag.apro_alu='No Aprobado' AND a.sex_per='v_gen' AND s.id_sed='v_sed' AND j.id_jor='v_jor' AND c.cod_cur='v_cur'