November 22nd, 2003, 09:58 AM
Join Date: Nov 2003
Location: A Red Glitter Coffin
Time spent in forums: 10 h 28 m 24 sec
Reputation Power: 0
Oh, the example was simplified.
I had a table of REFs and i wanted to see if a certain REF was in it, i couldn't use equals because it gave me an error saying single row subquery only or something like that...
It wouldn't work, but it does for IN
here's the statement...
SELECT s.stuid, s.name, s.age
FROM studentmembers s
WHERE REF(s) IN
(SELECT * FROM TABLE
WHERE id = 1));
It wouldn't work with equals, but it does with IN!