```
id    player_id nat nt_caps
13740   28664   97  24  
13741   28664   68  0   
13742   28664   79  0   
16252   42904   15  40  
16253   42904   68  0   
16254   42904   241 0   

```

That's how my table looks. I want to select the player\_id's that have either nt\_caps = "0" for every nat OR player\_id's that have nt\_caps != "0" only for nat = "68".

The SQL query I try to use is:

```
SELECT player_id FROM x WHERE nat = '68' AND (nat != '68' AND nt_caps = '0')

```

But then I get player\_id '42904' and '28664' because they both have 1 entry that matches the query but I don't want them because they have nt\_caps for another nat than nat "68".

I hope you understand what I try to achieve.