Anonymous

SELECT `propriete`.`propriete`, `cout`.`prix` , `cout`.`coeff` , `cout`.`coeff_detail` , (`cout`.`prix` * `cout`.`coeff`) AS total, cout.type as cout_type, societe_composant_desordre.id_societe_composant , societe_composant_desordre.niveau 	, societe_composant_desordre.pourcent, societe_composant_desordre.travaux, `propriete`.`desordre` FROM coutINNER JOIN propriete ON propriete.id_propriete = cout.id_proprieteINNER JOIN societe_composant ON (cout.`id_societe` = societe_composant.`id_societe` AND propriete.id_composant=societe_composant.id_composant)LEFT JOIN societe_composant_desordre ON societe_composant_desordre.`id_societe_composant` = societe_composant.`id_societe_composant`WHERE cout.`id_societe` =3516