Salut à tous!
Une petite erreur tte simple!
(enfin j'espère)
J'ai un table (wa) avec deux colonnes de foreign key (w_id et p_id)
SELECT t.w_id
FROM wa AS t, (
SELECT pid
FROM wa
WHERE w_id =298
) AS p,
WHERE p.pid = t.pid
GROUP BY w_id
LIMIT 0 , 30
MySQL a répondu:Documentation
#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 'WHERE p.pid = t.pid
GROUP BY w_id
LIMIT 0 , 30' at line 8
Merci