inner join and sum()

inner join and sum()

I Have two tables trips_data which as tripid, userid, species
(int),killcount masterspecies which had species_id and speceies (string)
I am trying to retrieve a list of all species seen on a trip I am hoping
to get
sum(killcount) : tripid :species (string):species (int)
57 300 rabbit 1
2 300 foxes 2
1 300 squirels 8
and so on
i have the below query which returns everything I want except the
sum(killcount) is about 8000 when it should be 57.
Any help would be hugely apreciated
SELECT sum(trips_data.killcount),
trips_data.species,trips_data.spceces,
masterspecies.species
from trips_data
join masterspecies
WHERE tripid=$tripid
AND userid=1
AND NOT killcount=0