Re: SQL works in 10g, not in 8i

Sybrand,

Thanks for your response. I did change it and put it in the from clause.
But I'm still having problems using that summed field. Look here below: I simplified it.
How can I use the ---- SUM(A.UNAMORT_PREM_DISC_BAL) ----- in my select statement.
I tried C.SUM(A.UNAMORT_PREM_DISC_BAL) or something similar, but it doesn't work.

Thanks
Roberto

Select AS_OF_DATE, b.CD_ID,DEALNO ,b.SECID, c.Secid

FROM FASDIG.CALLABLE_DEAL B ,
(SELECT A.secid, SUM(A.UNAMORT_PREM_DISC_BAL) FROM FASDIG.CALLABLE_DEAL A
WHERE A.AS_OF_DATE = ADD_MONTHS('30-sep-2005',-2) group by A.secid) C

WHERE AS_OF_DATE = '31-jan-2005' AND HEDGED_FLAG='Y' AND PREM_DISC_AMOUNT <>0 AND PREM_DISC_IND ='D'

GROUP BY
AS_OF_DATE, CD_ID, DEALNO , b.SECID, PREM_DISC_AMOUNT, EST_MDATE, START_AMORT_DATE , c.Secid