hiya, i'm pretty new to Oracle so any helped would be great, ta
Error: An exception was raised on the server: ORA-00904: "YEAR": invalid identifier
Start of SQL Statement
================================================================================
SELECT DISTINCT SUM(TRANS.GROSSAMOUNT), TRANS.REF3, TO_CHAR(TRANS.TRANSDATE,'YYYYMM'), TRANS.REF3 ||TO_CHAR(TRANS.TRANSDATE,'MM'), TRANS.RECTYPE FROM TRANS WHERE (TRANS.RECTYPE = 'GFT' OR TRANS.RECTYPE = 'NOR' OR TRANS.RECTYPE = 'NGA' OR TRANS.RECTYPE = 'CCY' OR TRANS.RECTYPE = 'PAY' OR TRANS.RECTYPE = 'CAF' OR TRANS.RECTYPE = 'COV' OR TRANS.RECTYPE= 'LEG') AND (MONTH(NVL(TRANS.PLEDGEDDATE,TRANS.TRANSDATE))=01 AND YEAR(NVL(TRANS.PLEDGEDDATE,TRANS.TRANSDATE)) =2008) GROUP BY TRANS.REF3, TO_CHAR(TRANS.TRANSDATE,'YYYYMM'), TRANS.REF3 ||TO_CHAR(TRANS.TRANSDATE,'MM'), TRANS.RECTYPE ORDER BY 3, TRANS.REF3, 1, 4, TRANS.RECTYPE