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 =59)) or (ad.ModuleType=2 and ad.AccessValue =59)) group by ad.ViewAccessID |
1
|
1
|
0
|
|
0.00
|