求改一段SQL文

SELECT F.COMPANY_NAME, SUM(F.AMOUNT) AS SUM_AMOUNT,C.CREDIT_AMOUNT
FROM FORM_COMTRACT F ,COMPANY_INFORMATION CI ,CREDIT_GRADE C
WHERE (F.SALES_MAN_NAME = '黄' AND F.COMPANY_NAME = CI.COMPANY_NAME AND CI.USER_GRADE_NAME = C.USER_GRADE_NAME )
GROUP BY F.COMPANY_NAME

谁能帮你改下 ，让它能执行

SELECT F.COMPANY_NAME, SUM(F.AMOUNT) AS SUM_AMOUNT,C.CREDIT_AMOUNT
FROM FORM_COMTRACT F ,COMPANY_INFORMATION CI ,CREDIT_GRADE C
WHERE (F.SALES_MAN_NAME = '黄' AND F.COMPANY_NAME = CI.COMPANY_NAME AND CI.USER_GRADE_NAME = C.USER_GRADE_NAME )
GROUP BY F.COMPANY_NAME,C.CREDIT_AMOUNT
或者
SELECT F.COMPANY_NAME, SUM(F.AMOUNT) AS SUM_AMOUNT,sum（C.CREDIT_AMOUNT ）
FROM FORM_COMTRACT F ,COMPANY_INFORMATION CI ,CREDIT_GRADE C
WHERE (F.SALES_MAN_NAME = '黄' AND F.COMPANY_NAME = CI.COMPANY_NAME AND CI.USER_GRADE_NAME = C.USER_GRADE_NAME )
GROUP BY F.COMPANY_NAME

看你究竟想查什么了，select后面跟的，没有sum的，一定都要放到groupby后面，不然执行不了

SELECT F.COMPANY_NAME, SUM(F.AMOUNT) AS SUM_AMOUNT,C.CREDIT_AMOUNT
FROM FORM_COMTRACT F ,COMPANY_INFORMATION CI ,CREDIT_GRADE C
WHERE (F.SALES_MAN_NAME = '黄' AND F.COMPANY_NAME = CI.COMPANY_NAME AND CI.USER_GRADE_NAME = C.USER_GRADE_NAME )
group BY F.COMPANY_NAME ,C.CREDIT_AMOUNT