select nom_sed as SEDE,des_jor as JORNADA,des_gra as GRADO,des_cur as CURSO, id_alu as CODIGO, a.id_per as DOCUMENTO,ape_per as APELLIDO,nom_per as NOMBRE
from alumno a
inner join (select id_pre as id_alu from preinscrito) p using(id_alu)
inner join alum_grado using(id_alu)
inner join grado using(cod_gra)
left join alumcurso using(id_alu)
left join curso using(cod_cur)
left join sede using(id_sed)
left join jornada using(id_jor)
where id_alu not in(select id_alu from bkC2011.alumno  )
order by nom_sed,des_jor,ord_gra,gru_cur,ape_per,nom_per