urgent question from novice [message #366662] |
Mon, 21 August 2000 13:45 |
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));
|
|
|
|