Advertisement
rstx2

editLeave

Nov 23rd, 2020
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. select * from dbo.LeaveData
  2. join dbo.Employee on LeaveData.EmpID = Employee.EmpID
  3. join dbo.PartLang on Employee.PartID = PartLang.PartID
  4. where dbo.LeaveData.Status_Line = 1
  5. and dbo.LeaveData.EditRequest = 1
  6. and dbo.PartLang.LanguageID = 'en'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement