Sobre consulta con select multitabla.

[joserodriguezan]

Ya lo tengo hecho, jopes si que le di vueltas.

SELECT c.nomcurs,
r.anyo,
r.numordre,min(a.assistencia) AS min_ass,
max(a.assistencia) AS max_ass,
format(avg(a.assistencia),2) AS avg_ass,
min(a.nota) AS min_nota,
max(a.nota) AS max_nota,
format(avg(a.nota),2) AS avg_nota
FROM alumnescurs a
right join cursos c on a.codicurs=c.codicurs
right join realitzaciocurs r on r.codicurs=c.codicurs
group BY c.codicurs;