A simple subquery:


SELECT T2.id FROM T2 WHERE T2.fid IN
(SELECT T2.id FROM T2 WHERE T2.fid = 8);

MySQL returns:

Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'SELECT T2.id FROM T2 WHERE T2.fid...

However, I can run them separately, e.g.

1.

SELECT T2.id FROM T2 WHERE T2.fid IN (1,2,3);

or

SELECT T2.id FROM T2 WHERE T2.fid = 8;


Any idea?

Thanks.

On Tue, 13 May 2008 11:49:28 +0200, howa <howachen (AT) gmail (DOT) com> wrote:

Version?

Avoid subqueries if you can:

SELECT x.id
FROM T2 x
JOIN T2 y
ON y.fid = 8 AND x.fid = y.id
GROUP BY x.id

--
Rik Wasmus
[SPAM] Now temporarily looking for some smaller PHP/MySQL projects/work to
fund a self developed bigger project, mail me at rik at rwasmus.nl. [/SPAM]