kalle123

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.

Hi. First a sample of the XML I'm trying to read using XML DOM: <team_data> <team_players> <player> <player_name></player_name> </player> <player> <player_name></player_name> </player> </team_players> </team_data> I'm trying to loop the DOM to read every players name (there're more than two players and different numbers of players). Can anyone help me?