Impossible de récupérer les informations sur le secteur : SELECT s_a.*, count(id_act) as nb_act FROM secteur_activite as s_a LEFT JOIN activite as act ON act.id_sect = s_a.id_sect WHERE s_a.id_sect = GROUP BY s_a.id_sect;