This is my Select Statment for my Webpage.
Sql = "select SUBJECTS, ORG_LEVEL_1, RECORD_OWNER, DELETION_DATE "_
& "from XML_EXPORT "_
& "order by SUBJECTS;"
I want to use the GROUP BY Clause to Group my Subjects togeather.
When I try adding the line (group by SUBJECTS)
I get this error.
"You tried to execute a query that does not include the specified expression 'ORG_LEVEL_1' as part of an aggregate function. " What should I do?
My Subjects will have multiple values that are equal. For example, Abuse and Abuse, When I display it currently with the Select Statement I am currently using, It displays Abuse for each time it is show in the Database. I just want it to show it only once, then group all the fields that are related to it togeather.