不好意思各位大大請教我下列oracle查詢語句出來的值會員編號要排除多個值該如何下?
Google似乎找不到合適寫法

select distinct ms.member_code 會員編號, ms.chinese_name 姓名,
ms.Phone_Night 手機, ms.Phone_Day 電話, ms.address 地址, ms.e_mail 郵件, sps.shop_cname 店名, to_char(dh.inv_date,'YYYY/MM/DD') 消費日期
from membership ms

join dinv_hdr dh ON (dh.shop_code = ms.shop_code)  --關聯資料表門店中文
join shop sps ON (sps.shop_code = dh.shop_code)

 where to_char(dh.inv_date,'yyyy/mm/dd') >= '2022/07/01'  and to_char(dh.inv_date,'yyyy/mm/dd') <= '2022/12/31' 
    and dh.closed = '1' AND dh.voided='0'
    and dh.member_code in (
        select member_code from membership
       where sps.shop_cname ='OK 高新櫃'
    )
    group by ms.member_code, ms.chinese_name, ms.Phone_Night, 
    ms.Phone_Day, ms.address, ms.e_mail, sps.shop_cname,  to_char(dh.inv_date,'YYYY/MM/DD')
    
    order by ms.member_code ASC