SELECT C.titulo AS Curso, CONCAT (A.apellidos, ' ', A.nombre)
AS Alumno
FROM cursos AS C LEFT JOIN alumnos_cursos AS AC
ON C.id_curso = AC.id_curso LEFT JOIN alumnos AS A
ON AC.id_alumno = A.id_alumno