IN operator problem

[Eric]

Hello All,

New to MySQL so I hope this is a very simple issue:

Why won't this query run?

SELECT ID from CONSTR where ID in (select distinct OLD_ID from results);

In my database this query works ok
SELECT ID from CONSTR where ID in (1);

This query also works ok:
select distinct OLD_ID from results;

I am used to doing this type of query in Oracle but I cannot figure out why it does not work in My SQL.

In the documentation for IN operator and exampel is given like this:
SELECT s1 FROM t1 WHERE s1 IN (SELECT s1 FROM t2);
That looks just like mine?

Thanks I am sure I am not seeing somehting easy (I hope!)