Seleccionar Alumnos sin notas

[Genetix]

Prueba usando LEFT JOIN

Código sql:

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