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

From: <rgiannic_at_gmail.com>
Date: 26 Sep 2005 13:34:50 -0700
Message-ID: <1127766890.783068.12180@z14g2000cwz.googlegroups.com>

GOT IT: Select AS_OF_DATE, b.CD_ID,DEALNO ,b.SECID, c.Secid, c.SumUPDB

FROM FASDIG.CALLABLE_DEAL B ,
(SELECT A.secid, SUM(A.UNAMORT_PREM_DISC_BAL) SumUPDB 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' and b.secid = c.secid

GROUP BY
AS_OF_DATE, CD_ID, DEALNO , b.SECID, PREM_DISC_AMOUNT, EST_MDATE, START_AMORT_DATE , c.Secid, c.SumUPDB Received on Mon Sep 26 2005 - 15:34:50 CDT