PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Select ve.Branch,count(ve.ID) 'No of Available Employees ' from [22.214.171.124].HumanResources.dbo.vwEmployee ve left join [126.96.36.199].HumanResources.dbo.vwBranch vb on ve.branch=vb.Name where ve.leavingdate is null group by ve.branch order by ve.Branch Select D.Branch,D.Employees 'No of Registered Employees' from (select A.Branch,count(A.EmployeeID)'Employees' from (select E.EmployeeID,E.Firstname,E.Lastname,B.Branch from dbo.tblEmployee E left join dbo.tblBranch B on E.BranchID=B.BranchID left join [188.8.131.52].HumanResources.dbo.vwEmployee VE on E.EmployeeID =VE.ID where VE.LeavingDate is null )A group by A.Branch )D order by D.Branch
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.