| Author |
 Topic  |
|
|
kefka1911
Starting Member
Canada
8 Posts |
 Posted - 29 October 2004 : 11:10:16
|
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? |
Edited by - ruirib on 29 October 2004 15:25:16 |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
kefka1911
Starting Member
Canada
8 Posts |
Posted - 29 October 2004 : 14:54:27
|
| What good does that do me, it doesn't do any actual grouping, I want to group all like Subjects togeather so I don't have any duplicates |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 29 October 2004 : 15:24:32
|
kefka1911, this forum is for posts related to Snitz problems while using Access DBs. All other posts should be made in the Community Discussions forums (either ASP or All Other Subjects).
I'm moving this post to the proper forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 29 October 2004 : 17:31:33
|
select distinct(SUBJECTS), ORG_LEVEL_1, RECORD_OWNER, DELETION_DATE
from XML_EXPORT
group by ORG_LEVEL_1, RECORD_OWNER, DELETION_DATE
|
Erick
Snowmobile Fanatics
|
|
|
| |
Topic |
|
Topic Locked
