I have three tables, history table, office table and invoice .
I Want to total count of each office who has sent the invoice based on the criteria that matches.

This is my query please help me.


Code:
SELECT DISTINCT TOP (100) PERCENT dbo.tbl_jobHistory.RCN, dbo.tbl_invoice.Date, dbo.tbl_office.officeName
FROM         dbo.tbl_jobHistory INNER JOIN
              dbo.tbl_office ON    dbo.tbl_jobHistory.officeID
...