Re: Counting two columns with where causes for each

From: Michael J. Moore <hicamel_x_the_spam_at_attbi.com>
Date: Tue, 10 Sep 2002 22:45:50 GMT
Message-ID: <xCuf9.277631$aA.47837_at_sccrnsc02>


in that case, how about...
select district,race,count(jobs),count(date_for_raise) from info where district||race in
(select distinct district||race from info where job=15 or date_for_raise is not null)
group by district,race

Mike

"Matt Novinger" <aeaas_at_yahoo.com> wrote in message news: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
> 4 3 11 0
> 7 5 3 25
>
> 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?
Received on Wed Sep 11 2002 - 00:45:50 CEST

Original text of this message