");
$requet="
SELECT distinct `table3`.`Num1` as `X`, count(`table3`.`Champ4`) as `Y`
FROM `table1`, `table3`, `table2`
Where `table1`.`Num1`= `table3`.`Num1` AND `table2`.`Num2`=`table3`.`Num2`
group by `table3`.`Num2`
having `Y` <= '2'
order by `Y`";
$result=mysql_query($requet) or die("erreur de requete de base de données.
");
?>
| X |
Y |
$num |
$mont |
";
$ligne= mysql_fetch_row($result);
}
?>