|
-
Jul 20th, 2005, 08:29 AM
#8
Thread Starter
Frenzied Member
Re: Getting min values via sql
No, that didn't work either, thanks though.
Yes, szalamany, you're correct. The query should only return the records with the minimum value for each question/module combination, including any records that both may have the minimum value.
So if a particular question is asked in say, 6 modules, there should be at least 6 records for that question, possibly a few more if there are more than one client in a module who also have the minimum value.
What I don't want are records for every question/module for each client, which is what I'm getting now. There should only be a few clients at most in any particular question/module combination. I'd zip the file & attach it, but not allowed to do that.
I can get sort of what I want by filtering in the table on the question, then the module, then minimum value. Unfortunately, that only returns one question/module combination.
Tengo mas preguntas que contestas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|