SELECT
TableHydrant.idHydrant AS idHydrant,
TableAnomalies.anomaliesHydrant AS anomaliesHydrant,
TableHydrantsAnomalies.numeroAnomalie AS numeroAnomalie,
TableCommunes.commune AS commune
FROM
TableCommunes,
TableHydrantsAnomalies,
TableAnomalies,
TableHydrant
WHERE
TableAnomalies.numeroAnomalie = TableHydrantsAnomalies.numeroAnomalie
AND TableHydrant.idHydrant = TableHydrantsAnomalies.idHydrant
AND TableCommunes.inseeCommune = TableHydrant.inseeCommune
AND
(
TableCommunes.commune LIKE {Param_commune}%
)
ORDER BY
idHydrant ASC
Cette contribution était de : http://old.wdforge.org/newbb/viewtopic.php?forum=18&topic_id=5677&post_id=23262