All pastes #913850 Raw Edit

Anonymous

public sql v1 · immutable
·published 2008-02-22 11:34 UTC
rendered paste body
SELECT `propriete`.`propriete` , `cout`.`prix` , `cout`.`coeff` , (`cout`.`prix` * `cout`.`coeff`) AS total, propriete.`desordre`,cout.type as cout_typeFROM coutINNER JOIN propriete ON propriete.id_propriete = cout.id_proprieteWHERE cout.`id_societe` =3516