SELECT... NOT IN (Faire une sous-requete et exclure des enregistrements)
SELECT * FROM cours WHERE id_cours NOT IN (SELECT id_cours FROM cours_dates)
mysqlinfo:mysql:select_without
SELECT * FROM cours WHERE id_cours NOT IN (SELECT id_cours FROM cours_dates)