SELECT ADM.GROUP_ID, ADM.GROUP_NAME, ADM.CUG_ID, ADM.ADMIN_SUBS_ID,
ADM.MSISDN MSISDN_ADMIN, ADM.SUBSCRIPTION_STATE ADMIN_STATE,
SUBS.MSISDN MEMBER_MSISDN, SUBS.SUBSCRIPTION_ID,
SUBS.SUBSCRIPTION_STATE MEMBER_STATE,
SUBS.GROUP_ID_1, SUBS.GROUP_ID_2, SUBS.GROUP_ID_3
FROM
(SELECT DISTINCT GROUP_ID, GROUP_NAME, CUG_ID, ADMIN_SUBS_ID,
MSISDN, SUBSCRIPTION_STATE, GROUP_ID_1, GROUP_ID_2, GROUP_ID_3
FROM PMS.PMS_GROUP G
LEFT JOIN PMS.PMS_SUBSCRIPTION S
ON SUBSCRIPTION_ID = ADMIN_SUBS_ID
WHERE SUBSCRIPTION_STATE = 5) ADM
LEFT JOIN
PMS.PMS_SUBSCRIPTION SUBS
ON (ADM.GROUP_ID = SUBS.GROUP_ID_1
OR ADM.GROUP_ID = SUBS.GROUP_ID_2
OR ADM.GROUP_ID = SUBS.GROUP_ID_3)
WHERE ADM.MSISDN <> SUBS.MSISDN
AND SUBS.SUBSCRIPTION_STATE = 2
ORDER BY ADM.GROUP_ID;
If I apply it, the query comes back and shows me the repeated data
What I want is to keep me from repeating data