SELECT `propriete`.`propriete` , `cout`.`prix` , `cout`.`coeff` , (
`cout`.`prix` * `cout`.`coeff`
) AS total, propriete.`desordre`
,cout.type as cout_type
FROM 
cout
INNER JOIN propriete ON propriete.id_propriete = cout.id_propriete
WHERE cout.`id_societe` =3516