rolebased sql list

 SELECT 

  F.FormID, 

  F.GroupID,

  FG.GroupName AS GroupName, 

  F.FormName, 

  F.UpdatedOn, 

  F.UpdatedBy, 

  F.IsActive, 

  FG.GroupName

FROM [tbl_Forms] F

JOIN [tbl_FormGroups] FG ON F.GroupID = FG.GroupID

JOIN [tbl_Users] U ON F.UpdatedBy = U.UserID

JOIN [tbl_UserRoles] UR ON U.RoleID = UR.RoleID

WHERE F.IsActive = 1

AND UR.RoleName IN ('superadmin', 'divcountryadmin');