报错：SQL语句未正常结束。检查了好几遍没看出来?报错

SELECT DISTINCT pnum                           ,
        incost4.pname                          ,
        t.ctotalcashier                        ,
        (cbed           +cmedicine+ctreat+ccheck)       AS ctotal,
        (t.ctotalcashier-(cbed+cmedicine+ctreat+ccheck))AS cbalance
FROM    incost4,
        cost   ,
        payment,
        (
                SELECT pname,SUM(cashier)AS ctotalcashier FROM payment GROUP BY pname
        )AS t
WHERE   cost.pname    =payment.pname
        AND cost.pname=incost4.pname
        AND t.pname   =cost.pname
ORDER BY cbalance