How about:



Select gender, action, count(ActionTaken)

From Applicants

Group by gender, action



Am I missing something?



Louis Kleiman

SSTMS, Inc.



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Clay Shannon
Sent: Friday, April 22, 2005 2:51 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] This SQL conundrum is breaking my head



From a table that stores such things about a job applicant as gender, race,
disability, veteran status, etc. and which table also holds an "Action
taken" column (which can be:



Hired

Not Interviewed

Interviewed-job declined

Did not meet qualifications

Etc.



I need to be able to see which actions were taken by gender, by race, etc.



The only "start" that I can come up with is something like:



Select gender, Count(ActionTaken)

From Applicants

Where Action = Hired

Group by Gender



But I need the results for every action taken, not just "Hired" - I need
results like:



Gender Hired Not Interviewed Did Not
Meet Quals

Male 2 3
2

Female 3 2
1



Clay Shannon,

Dimension 4 Software





[Non-text portions of this message have been removed]




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms
<http://docs.yahoo.com/info/terms/> of Service.



[Non-text portions of this message have been removed]