Seleccionar Alumnos sin notas

[Genetix]

Hola

Prueba esto

Código sql:

SELECT * FROM alumnos AS t1 JOIN notas AS t2 ON t1.idAdlumno = t2.idAlumno
WHERE t2.nota = "" OR t2.nota IS NULL