优先级问题,加个括号
(归属门店 In (Select fchrStoreCode from {VIP管理人员对应门店} where fchrLandName= 'R0001' ) or 归属门店 = 'R0001') and ( VIP卡号='216053')