怎么写这个SQL语句???
Access是这么写的:
select Sum(IIf([AMCV by MIF(3M)]![AMCV] Is Not Null,[AMCV by MIF(3M)]![AMCV],IIf([AMCV by MIF(6M)]![AMCV] Is Not Null,[AMCV by MIF(6M)]![AMCV],IIf([AMCV by MIF(Other)]![AMCV] Is Not Null,[AMCV by MIF(Other)]![AMCV],[TESSERACT_ASO_MONTHLY_REPORT_FACTOR]![Y1999_ACTUAL_AMCV])))) AS AMCV
Oracle对应的怎么写啊???请高手多指点,才接触Oracle没多久