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
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