SELECT SUM(orders.quantity) AS num, fName, surname
FROM author
INNER JOIN book ON author.aID = book.authorID;
SELECT SUM(orders.quantity) AS num, fName, surn
阅读背景：
MS-Access - 您尝试执行不包含指定聚合函数的查询
来源：互联网
分享到：
