Voila la requete:
Code : Tout sélectionner
SELECT COUNT( * ) AS NB, c.X, c.Y, Z
FROM t1 AS c, t2 AS s
WHERE s.X = c.X
AND c.X NOT
IN (
SELECT M FROM t3
WHERE N >= c.Y
)
GROUP BY c.X, c.Y
ORDER BY Z
Si qq'un voit d'ou vient le soucis, merci d'avance.#1064 - You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT M FROM t3 WHERE N>=c.Y ) GROU
Wells
