我在寫一個View 時發現一個問題. 就是用IF 語法. 我照了手冊上的方式去寫? 為何還不行呢? (IF (D.M_unit == 'M') THEN (D.M_Cost / 0.9144 ) ELSE D.M_Cost END IF ) M_Cost2 下面是全部的內容--------------------- SELECT D.*, round(D .M_Sell * D .M_Num, 0) AS M_Total, round(D .M_Sell * D .M_Num * 1.05, 0) AS T_Total, M.M_Custom AS M_Custom, M.M_Out_Date AS M_Out_Date, M.M_Fashion AS M_Fashion, M.M_Day AS M_Day, M.M_Close AS M_Close, M.M_Dead_Date AS M_Dead_Date, M.M_Sales AS M_Sales, M.M_Assistant AS M_Assistant, (IF (D.M_unit == 'M') THEN (D.M_Cost / 0.9144 ) ELSE D.M_Cost END IF ) M_Cost2 FROM M_Account4 D,M_Account M where D.M_No= M.M_No( )

Hi weiliching,    PL/SQL !! Do you use Oracle as your DataBase !?    Try below codes :

SELECT  D.*,
        ROUND(D .M_SELL * D .M_NUM, 0) AS M_TOTAL, 
        ROUND(D .M_SELL * D .M_NUM * 1.05, 0) AS T_TOTAL, 
        M.M_CUSTOM AS M_CUSTOM, 
        M.M_OUT_DATE AS M_OUT_DATE, 
        M.M_FASHION AS M_FASHION, 
        M.M_DAY AS M_DAY, 
        M.M_CLOSE AS M_CLOSE, 
        M.M_DEAD_DATE AS M_DEAD_DATE,
        M.M_SALES AS M_SALES, 
        M.M_ASSISTANT AS M_ASSISTANT,
        DECODE(D.M_UNIT,'M',D.M_COST / 0.9144,D.M_COST) AS M_COST2
FROM    M_ACCOUNT4 D,M_ACCOUNT M 
WHERE   D.M_NO= M.M_NO( )

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman