How to join two Select?

[Matteo Giudici]

I've migrated a mdb-access to mysql how can I write this query to be used in mysql query broswer?

SELECT First([Studente-giorno-ora].studente) AS studenteCampo, First([Studente-giorno-ora].data) AS dataCampo, First([Studente-giorno-ora].ora) AS oraCampo, Count([Studente-giorno-ora].studente) AS NumDuplicati
FROM [Studente-giorno-ora]
GROUP BY [Studente-giorno-ora].studente, [Studente-giorno-ora].data, [Studente-giorno-ora].ora
HAVING (((Count([Studente-giorno-ora].studente))>1) AND ((Count([Studente-giorno-ora].ora))>1));


Studente-giorno-ora is
SELECT newstudlesson.studente, newlesson.data, newlesson.ora
FROM newlesson INNER JOIN newstudlesson ON newlesson.id = newstudlesson.id_lezione;

Thank you for your help.
Matteo