Home » Developer & Programmer » JDeveloper, Java & XML » urgent question from novice
urgent question from novice [message #366662] Mon, 21 August 2000 13:45 Go to next message
Messages: 1
Registered: August 2000
Junior Member
I need some help here. Could someone tell me what is wrong with my query? (I am getting the following error:
java.sql.SQLException: type mismatch in function #EQU)
SELECT i1.cusip, i1.ssic1 , i1.ssic2 , i1.s5 , i2.s5, i2.cusip
FROM indseg i1, indseg i2
where i2.segn=1 and i2.ssic1 in (SELECT cusip,segn,ssic1,ssic2
FROM indseg
WHERE segn >= 3 AND
ssic1 NOT BETWEEN 4100 AND 4999 AND
ssic1 NOT BETWEEN 6000 AND 6799 AND
ssic2 NOT BETWEEN 4100 AND 4999 AND
ssic2 NOT BETWEEN 6000 AND 6799 AND
group by i1.cusip
having min(abs(i1.s5-i2.s5));
Re: urgent question from novice [message #366665 is a reply to message #366662] Thu, 24 August 2000 10:41 Go to previous message
Messages: 17
Registered: December 1999
Junior Member
In your subquery, it should return one column which matches the column In clause.

select col1, col2
from tab1
where col1 in (select col3 from tab2);
Previous Topic: Table Locking Using JDBC
Next Topic: Urgent : A query regarding Oracle Java Cartridge
Goto Forum:

Current Time: Wed Jul 28 21:53:21 CDT 2021