On Tue, 13 May 2008 11:49:28 +0200, howa <howachen@gmail.com> wrote:

> 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?

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]