ry

Select A.ID as AccountingID, Sum(M.Cost) as TotalService

From Accounting A

INNER JOHN MaintenanceServiceMgmt M ON A.ID = M.Accounting_ID --this is assuming there is a fk called Accounting_ID that is linked to Accounting.ID

Group By A.ID