我正在尝试列出数据库中有一本书的所有出版商。
查询:
SELECT Publisher
FROM book
GROUP BY Publisher
HAVING COUNT(book) = 1;
我的猜测是问题就在这里...
HAVING COUNT(book) = 1
该表名为 book
。 除非该表还包含名为 book
的字段,否则 Access 将被混淆。
如果您想查看只有一行Publisher
,请使用此...
SELECT Publisher
FROM book
GROUP BY Publisher
HAVING COUNT(*) = 1;