sql count by company

[sagey]

i want to return a count of the number of lproductid's for each company, so far i have this query

select count(lproductid), companyname, customeragreementsent, customeragreementback
from tblcompanies
inner join tblCustomerAgreements as ca on tblcompanies.companyid = ca.companyid
inner join tblallsubscribercodes as tas on ca.companyid = tas.companyid
inner join ilabelserver.dbo.subscriber as isub on tas.subscribercode
= isub.smanucode
inner join ilabelserver.dbo.product as iprod on isub.lsubscriberid =
iprod.lsubscriberid
where customeragreementsent is not null and customeragreementback is null
group by lproductid, companyname,customeragreementsent, customeragreementback

but this does not pull back the correct results.
can anyone help?

[PilgrimPete]

Trim your GROUP BY clause:

from

group by lproductid, companyname,customeragreementsent, customeragreementback

to

group by companyname