Unir 2 tablas

[videlxu]

Código MySQL:

SELECT *
 
FROM alumno AS alum
 
INNER JOIN (
SELECT *
FROM notas
) AS nota ON alum.cod_alu = nota.Cod_alu 
WHERE alum.carrera='".$carrera."' AND  nota.CICLO = '".$ciclo."' GROUP BY alum.ape_pat ASC