IN operator problem
Posted by:
Eric
Date: August 25, 2004 09:37AM
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!)
Subject
Written By
Posted
IN operator problem
August 25, 2004 09:37AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.