");
$requet="
SELECT `table3`.`Num1` as `X`, avg(`table2`.`Champ3` * `table3`.`Champ4`) as `Y`
FROM `table1`, `table3`, `table2`
Where `table1`.`Num1`= `table3`.`Num1` AND `table2`.`Num2`=`table3`.`Num2`
group by `table3`.`Num1`
having `Y` <= '15000'
order by `Y`";
// and `table1`.`Date1` >= '2018-01-10' and `table1`.`Date1` <= '2018-01-13'
$result=mysql_query($requet) or die("erreur de requete de base de données.
");
?>
| X |
Y |
$num |
$mont |
";
$ligne= mysql_fetch_row($result);
}
?>