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
stajm
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
year=1992)
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
Cpchin
Messages: 17
Registered: December 1999
Junior Member
In your subquery, it should return one column which matches the column In clause.

example:
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