Table `entretien` does not have a column named no_candidature, why you have "ON candidature.no_candidature = entretien.no_candidature"
I'm not sure I understand what you're trying to do with the GROUP BY and HAVING there.
I would probably try to check
candidature.date_candidature = entretien.date_entretion
For the JOIN condition ...
You're right ,
But it's in french ,i hope that it's ok for you !
These are my two tables that I guess I have to make a JOIN in order to have the result:
Table 1 candidature (No_candidature,Date_candidature,No_poste_No_candidat)
Table 2 Entretien (no_entretien,date_entretien, durée_entretien)