select u.userid, u.LastName, u.FirstName, u.UserName,
u.Enterpriselevelaccess, u.Division, div.div_name,
u.title, u.company, u.email, ur.userrole,

CASE u.RMSAccess
WHEN 0 THEN  'None'
WHEN 1 THEN  'Read'
WHEN 2 THEN  'Edit'
ELSE ''
END as RMSAccess

from tab_users U inner join tab_userroles UR on (u.userid= ur.userid)
inner join tab_divisions Div  on ( u.division = div.divisionid )
where u.deleted=0 and 65 in (select userid from tab_userroles where userRole =1) order by 2,3,1