Hi @Bone_12 ，
The unselected data is returned because those data actually satisfy the conditions behind WHERE.
Maybe this is what you want:
and (e.cust_field='1' or e.cust_field='3' or e.cust_field='7'or e.cust_field='17' or e.cust_field='21'or e.cust_field='29'or e.cust_field='32' or e.cust_field='35')
If you have any question, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.