I want to join The empded in first table as total deductionHelpp
===

SELECT     empmst.FirstName + ' ' + empmst.MiddleName + ' ' + empmst.LastName AS FullName, SUM(empearn.Amount) AS TotalEarning
FROM         EmployeeEarnings AS empearn INNER JOIN
                      EmployeeMaster AS empmst ON empearn.EmployeeId = empmst.EmployeeId INNER JOIN
                      MstPayrollParaDefinition AS mstpara ON empearn.ParaId = mstpara.ParaId INNER JOIN
                      MonthlyPayroll AS mPay ON empearn.EmpPayrollProcessId = mPay.EmpPayrollProcessId
WHERE     (mPay.PayrollId = 1)
GROUP BY empmst.FirstName, empmst.MiddleName, empmst.LastName, empearn.EmployeeId

SELECT     SUM(empded.Amount) AS TotalDeduction
FROM         EmployeeDeduction AS empded INNER JOIN
                      EmployeeMaster AS empmst ON empded.EmployeeId = empmst.EmployeeId INNER JOIN
                      MstPayrollParaDefinition AS mstpara ON empded.ParaId = mstpara.ParaId INNER JOIN
                      MonthlyPayroll AS mPay ON empded.EmpPayrollProcessId = mPay.EmpPayrollProcessId
WHERE     (mPay.PayrollId = 1)
GROUP BY empded.EmployeeId 