You tried to execute a query that does not include the specified aggregate function
The error is because fName
is included in the SELECT
list, but is not included in a GROUP BY
clause and is not part of an aggregate function (Count()
, Min()
, Max()
, Sum()
, etc.)
You can fix that problem by including fName
in a GROUP BY
. But then you will face the same issue with surname
. So put both in the GROUP BY
:
SELECT
fName,
surname,
Count(*) AS num_rows
FROM
author
INNER JOIN book
ON author.aID = book.authorID;
GROUP BY
fName,
surname
Note I used Count(*)
where you wanted SUM(orders.quantity)
. However, orders
isn't included in the FROM
section of your query, so you must include it before you can Sum()
one of its fields.
If you have Access available, build the query in the query designer. It can help you understand what features are possible and apply the correct Access SQL syntax.
My SQL query states that my query does not include the specified expression as part of an aggregate function
Do it this way:
We missed EventRequest.dateheld from the group by
SELECT EventRequest.eventno, COUNT(EventPlan.planno) AS NumEvents,
EventRequest.dateheld
FROM EventRequest, EventPlan
WHERE EventRequest.eventno = EventPlan.eventno
AND workdate BETWEEN #01-Dec-2013# AND #31-Dec-2013#
Group BY EventRequest.eventno, EventRequest.dateheld;
Related Topics
Regular Expression to Match Common SQL Syntax
SQL Query: Simulating an "And" Over Several Rows Instead of Sub-Querying
Postgresql Order by Issue - Natural Sort
How to Sort a 'Version Number' Column Generically Using a SQL Server Query
Delete Parent If It's Not Referenced by Any Other Child
SQL Error "Ora-01722: Invalid Number"
SQL Error: Ora-00933: SQL Command Not Properly Ended
SQL Update Order of Evaluation
Equivalent Function for Dateadd() in Oracle
What Is the Equivalent Postgresql Syntax to Oracle's Connect by ... Start With
Does Oracle Use Short-Circuit Evaluation
Cross Join Without Duplicate Combinations
Oracle: Combine Multiple Results in a Subquery into a Single Comma-Separated Value