Post reply

Combining Two Grouping Select Statements

  • June 19, 2003 at 7:45 am

    #462120

    harrumph...mutter mutter

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

  • June 19, 2003 at 7:46 am

    #462121

    stax68,

    the problem is that your code will aggregate the COUNT(DataID) will not return a count of all questionnaire records, but just the count of the questionnaires in the group keyed on UDL4. What drewid is asking for is to include not only this grouped count, but also a count of the entire number of questionnaires. Regardless, DavidBurrows has posted an excellent solution.

  • June 19, 2003 at 7:55 am

    #462127

    jpipes - I understand the issue - I just disagreed about what was being asked for.

    Tim Wilkinson

    "If it doesn't work in practice, you're using the wrong theory"
    - Immanuel Kant

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply