Hey! I am struggling with a SQL statement that I have embedded in my Java code. This is the first time I've ever had problems with a SQL statement that works fine in Microsoft Access but does not compile in Java. A screen shot of my SQL is attached. It's pretty long, that's for sure, but not too complex.
The error I get is: "You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function." This is confusing because, as you can see in the SQL statement, this is not an aggregate statement. There's no grouping of any kind.
Any ideas? Like I said, works just fine in Access, but generates the above error in Java.
On observing the query, I guess, MS Access is treating the JOIN operation as an Aggregation functionality.
Not many get the right opportunity !
Joined: Jun 15, 2011
Madhan Sundararajan Devaki wrote:On observing the query, I guess, MS Access is treating the JOIN operation as an Aggregation functionality.
Thanks for the reply, Madhan. What makes you suspect that one of the JOIN operations is being treated as an aggregation functionality?
For what it's worth, I was able to get around this by simply embedding a SELECT * from the query object itself but this obviously isn't ideal (selecting all records from a query feels quite redundant).