How do I alter my code to get me the sum of that instead. Basically the correct response I need to get is 98.
SELECT COUNT(DISTINCT J.JobNo)FROM Jobs J JOIN JobsParties JP ON J.JobNo = JP.JobNo LEFT OUTER JOIN JobsPartiesSvc JPS ON JP.JobPartyNo = JPS.JobPartyNo LEFT OUTER JOIN Contacts C ON J.OrdContactNo = C.ContactNo LEFT OUTER JOIN Firms F ON C.FirmNo = F.FirmNo LEFT OUTER JOIN State S ON F.StateNo = S.StateNo LEFT OUTER JOIN Invoices I ON J.JobNo = I.JobNoWHERE J.Status NOT IN (712,812,811) AND I.Original = 1AND J.JobDate BETWEEN '7/1/08' and '7/15/08'AND J.BUNo = 11GROUP BY C.DisplayName, F.FirmName, F.Address, F.City, F.PostCode, S.StateName