Employee Count By Two Distinct Indicators

This seems simple enough, I'm trying to get a count of employees by different indicators. First total by job code, second by Union_Code.

So I'm looking to count every one by distinct job codes inside a distinct Union_code first, then total the number for that distinct union.

Any help would be appreciated.




SELECT emp.job_code,
tbljob.job_title,
emp.union_code

FROM emp

INNER JOIN
empjob ON empjob.emp_id = emp.emp_id
AND empjob.company = emp.company
AND empjob.job_code_id = 'PRIM'

INNER JOIN
tbljob ON tbljob.job_code = empjob.job_code
AND tbljob.company = empjob.company

WHERE (emp.company = 'ABC')
ORDER BY emp.union_code, empjob.job_code