select role member attributes

SELECT
*
FROM KRIM_ROLE_MBR_ATTR_DATA_T rmbrt
WHERE
rmbrt.ROLE_MBR_ID IN
(
  SELECT rmb.ROLE_MBR_ID FROM KRIM_ROLE_MBR_T rmb WHERE rmb.ROLE_ID='10543'
)