how to check if a logged in user has a certain department ID

Question

I have a table that has a user Id and aswell the Id of the department he/she belongs to. Now i want to write a code a to check if the logged in user belongs to department A OR B if they belong to either one of them  then they have certain access rights. (otherwise none)

Syed Shanu · Answer

Hi You can write a join query and get user detail and Depatment name. for example Select a.UserNameB.DepartmentName from yourUserTable a Inner Join DepartmentName B ON a.DeptID=B.DeptID where a.UserID='LoggedInUserID' with the aboue result you can find the department of logged in user. using this result you can perform your requirement.