Select      mr.RES_NAME,

            SG.WSEC_GRP_NAME

FROM MSP_RESOURCES MR

INNER JOIN MSP_WEB_SECURITY_GROUP_MEMBERS SGM ON (WRES_GUID = MR.RES_SECURITY_GUID)

INNER JOIN MSP_WEB_SECURITY_GROUPS SG ON (SG.WSEC_GRP_GUID = SGM.WSEC_GRP_GUID)

ORDER BY RES_NAME