Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.44 KB | None | 0 0
  1. SELECT
  2.     E.FirstName ,
  3.     E.LastName ,
  4.     SR.DateFrom,
  5.     AD.AdditionDeductionNr,
  6.     AD.Code
  7. FROM
  8.     dbo.Employe_Employes E
  9. INNER JOIN StaffSalary_Registers SR ON SR.EmployeeNr = E.EmployeNr
  10. INNER JOIN StaffSalary_RegisterValues RV on RV.RegisterNr = sr.RegisterNr
  11. INNER JOIN StaffSalary_AdditionsDeductions AD ON AD.AdditionDeductionNr = RV.AdditionDeductionNr     
  12. WHERE
  13.     SA.AdditionDeductionNr = @AdditionDeductionsNr
  14.     AND SR.DateFrom =  @monthNo
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement