TEXT TO lcSelect NOSHOW TEXTMERGE FLAGS 1 PRETEXT 15
SELECT aul.num_aula
, aul.situacion
, alu.alumno
, pro.profesor
, pag.nMatricula
, pag.Pension
from aula as aul
left join matricula as mat
ON aul.idaula = mat.idaula
left join alumno as alu
ON mat.idalumno = alu.idalumno
left join profesor as pro
ON mat.idprofesor = pro.idprofesor
left join pagos as pag
ON mat.idmatricula = pag.idmatricula
ENDTEXT