Select ad.ViewAccessID from sd_viewaccess_details ad,sd_project_roles rm,sd_project_roles_details rd where ad.ProjectID=1 and ad.ProjectID=rm.ProjectID and ((ad.ModuleType=1 and ad.AccessType=6 and (ad.AccessValue = rm.ProjectRoleID and rm.ProjectRoleID = rd.ProjectRoleID and rd.UserID =2252)) or (ad.ModuleType=2 and ad.AccessValue =2252)) group by ad.ViewAccessID |
2
|
10
|
3
|
|
0.00
|