SELECT CONCAT (A.apellidos,' ',A.nombre) AS Alumno, C.titulo
FROM alumnos AS A,cursos AS C, alumnos_cursos AS AC
WHERE A.id_alumno = AC.id_alumno
AND C.id_curso = AC.id_curso
AND A.nombre LIKE'%E%'