What's wrong with my SQL statement

[Alderaan]

OK, I have two factions and I want to sum the total Honor of each faction.

I store my player data under pwdata which looks like this:



Table: pwdata
tag name val
------ ------ -------
Player A FACTION CHAOS
Player A VILLAGE_HONOR 1000
Player B FACTION CHAOS
Player B VILLAGE_HONOR 800
Player C FACTION ORDER
Player C VILLAGE_HONOR 600


I want the total VILLAGE_HONOR for the CHAOS faction.

I run the following SQL querry

SELECT SUM(val) FROM pwdata WHERE name='VILLAGE_HONOR' AND tag IN (SELECT tag FROM pwdata WHERE val='CHAOS')

It isn't working. What am I doing wrong? and how can I correct this.

Thanks

[Manuel]

SUM() is for adding values together. You want to use COUNT().
_________________
I only know enough to be dangerous.

[Alderaan]

Adding the values is exatcly what I want. I want to get the total honor of each faction

[NoMercy]

Looking at it, apart from the horror of not having tables in a higher normal form, I guess your problem is most likely that your running SUM() on a text field.

[Manuel]

Yeah, that's what threw me so I assumed COUNT(). How does one SUM() 'CHAOS'?
_________________
I only know enough to be dangerous.

[NoMercy]

I'm confused why it's not working because normalyl "1" = 1 in MySQL, might need to do something like 0+val so it knows to convert it into a number...