SEO

#1 (**permalink**) 05-13-2008, 06:14 PM

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.

#2 (**permalink**) 05-13-2008, 06:14 PM

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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Subquery problem