Crystal Reports: Closed Tickets by Customer changes counts when adding Priority Grouping

Greetings all. New to the system and doing some Crystal Reports development and ran into an interesting situation. I first created a report to show closed tickets by Customer. This returned a count of tickets for each. I then joined the prioritydefinition table to further group the closed tickets for each customer by priority. When I ran the second report, the sum of tickets for the priorities was less than the "non-joined" report. I went through the report and validated some of the tickets that appeared in just the Closed for Company report but not in the Closed for Company by Priority report, and tickets that are missing do have a priority assigned.

Below is the SQL from the Crystal Report (Closed for Company by Priority). Any suggestions on what I may be doing wrong?

Thanks!

SELECT DISTINCT `accountdefinition1`.`ORG_NAME`, `statusdefinition1`.`STATUSNAME`, `workorder1`.`WORKORDERID`
FROM (((`servicedesk`.`workorderstates` `workorderstates1` INNER JOIN `servicedesk`.`workorder` `workorder1` ON `workorderstates1`.`WORKORDERID`=`workorder1`.`WORKORDERID`) INNER JOIN `servicedesk`.`statusdefinition` `statusdefinition1` ON `workorderstates1`.`STATUSID`=`statusdefinition1`.`STATUSID`) INNER JOIN `servicedesk`.`accountsitemapping` `accountsitemapping1` ON `workorder1`.`SITEID`=`accountsitemapping1`.`SITEID`) INNER JOIN `servicedesk`.`accountdefinition` `accountdefinition1` ON `accountsitemapping1`.`ACCOUNTID`=`accountdefinition1`.`ORG_ID`
ORDER BY `accountdefinition1`.`ORG_NAME`, `statusdefinition1`.`STATUSNAME`