SQL statement is failing. Why?

[Rich Bernstein]

I am trying to run the following statement:
SELECT cc.cost_center_name, cc.qualified_percent, SUM(e.w2_wages) as qualified_amount
FROM cost_center as cc,employees as e
WHERE e.email='$email' AND e.campaign='$campaign'
AND cc.email='$email' AND cc.campaign='$campaign'
AND cc.cost_center_name=e.department

This is supposed to get total all the wages for employees in each cost center. Instead it returns just this:
cost_center_name qualified_percent qualified_amount
test 0 267,000

"test" is one of the cost centers, but there are about 30 more. Why is it just doing "test"?