Re: Counting two columns with where causes for each
From: Matt Novinger <aeaas_at_yahoo.com>
Date: 10 Sep 2002 13:03:08 -0700
Message-ID: <19809582.0209101203.682279bf_at_posting.google.com>
Date: 10 Sep 2002 13:03:08 -0700
Message-ID: <19809582.0209101203.682279bf_at_posting.google.com>
I apologize for the typo, job=15 was in my initial query, not job=18
Thank you for the reply Mike, but I think I wasn't clear with what I
need displayed in my original post, I need something like this:
district | race | Count_of_Job | Count_of_Date
I need a count of the number of people with job 15 in a certain
district and of a certain race along with a count of the people who
have a date to be raised on in any given district and race as well,
the query Mike gave seems to only return one count?
4 3 11 0
7 5 3 25