MySQL SUM from Mulitple Tables
===

I have 2 tables: 'sending_fresh' and 'agents'

I would like to get the total where 'cc' equals the a certain date from 'sending_fresh' and a specific team from 'agents'

I currently have:

    SELECT SUM(sending_fresh.cc), agents.team  
    FROM sending_fresh, agents 
    WHERE agents.team = 'team1' 
    AND sending_fresh.date = '2012-05-12'

The sum works fine when selecting from just the 'sending_fresh' table but but comes with a much higher and wrong answer when adding a WHERE statement from a second table.

Can anyone help?