so I have a table with a row that describes each test
Each test has a minimum passing score. Each test can be run an arbitrary number of times so I have a table of scores, which uses
test id as a "foreign key".
what I would like to do is count the count of fails and passes. ideally in a single query.
so the test table lookes like this -------------------------------------- t_id . . . . min_pass_score ---------------------------------------
and the score table looks like this:
--------------------------------------- score_id t_id score . . . ---------------------------------------
I would like to select so the result set looks like this:
t_id no_passes no_fails ------------------------- 1 5 6 2 12 4 3 192 34 . . .
How can I do this? I have access to Mysql 4.0.18 although the production server still runs 3.23
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
