sql - 为什么此表达式在 MS-ACCESS SQL 视图中不起作用

Question

SELECT
    Pname,
    Dname,
    COUNT(WO.Essn),
    SUM(WO.Hours)
FROM
    PROJECT AS P,
    WORKS_ON AS WO,
    DEPARTMENT AS D
WHERE
    P.Dnum = D.Dnumber
    AND P.Pnumber = WO.Pno 
GROUP_BY Pno
HAVING
    COUNT(WO.Essn) > 1;

我正进入（状态

在查询表达式中。（错误 3075）

此代码错误。我应该改变什么

标签： sqldatabasems-accessdatabase-design

Answer 1

you're group by statement is not correct:

SELECT
    Pname,
    Dname,
    COUNT(WO.Essn),
    SUM(WO.Hours)
FROM
    PROJECT AS P,
    WORKS_ON AS WO,
    DEPARTMENT AS D
WHERE
    P.Dnum = D.Dnumber
    AND P.Pnumber = WO.Pno
GROUP BY  
    Pname,
    Dname
HAVING
    COUNT(WO.Essn) > 1;