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
Marsh Posté le 31-05-2006 à 13:30:31
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