Miscellany

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