SELECT 
    societe.* 
FROM 
    societe 
    INNER JOIN bon_de_commande ON bon_de_commande.id_fournisseur=societe.id_societe
WHERE 
    bon_de_commande.id_fournisseur=2020
GROUP BY 
    societe.id_societe