Sub-Selects (select ... in (select ...)) syntax error

[tiago251]

Hi all!

I always get a syntax error while using sub-selects (imbriqued selects).

I tried this request, from mySQL doc:

SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);

And got the same error. Nothing to see with the tables. My request was:

SELECT title FROM meeting WHERE meetingID IN (SELECT meetingID FROM action WHERE paul = 1);

meetingID a the primary key in both tables (but not the only one in table action).

Someone got an idea?
Using mySQL max 3.23.51 (latest version)
Thanks a lot!
::Tiago

 

[danielhozac]

I thought that they were still working on subselects. Maybe you read the docs for version 4 where this might be implemented. //Daniel