Well, I just realized that my previous explination probably confused
more than it explained, so here's my actuall query (with a bunch of
extraneous stuff cout out):
SELECT
hlstats_Awards.awardId,
hlstats_Events_Frags.playerId,
COUNT(hlstats_Events_Frags.weapon) AS awardcount
FROM
My current query is really complicated, so I'll only deal with my
simplified output here. I'm doing Half-Life stats program, and right
now I'm adding in awards to it. This is a snip from my current output:
+-+--++
| awardId | playerId | awardcount |
+-+-
