1: SELECT u.*

   2: FROM {databaseOwner}[{objectQualifier}Users] as u JOIN (

   3:             SELECT u.UserID

   4:             FROM {databaseOwner}[{objectQualifier}Roles] AS r JOIN {databaseOwner}[{objectQualifier}UserRoles] AS u

   5:             ON r.RoleID = u.RoleID

   6:             WHERE r.RoleName = 'Administrators'

   7:                ) AS r

   8: ON u.UserID = r.UserID