Need help with expression filter

[none888]

Hi, I have a report with stats and I want to exclude hands/tournaments(doesnt matter which I play heads up sit and goes) played vs certain players. I have a solution if I want to exclude just one player:

Code: Select all

tourney_hand_player_statistics.id_hand not in (SELECT ths.id_hand from tourney_hand_summary ths where ths.id_tourney in (select tr.id_tourney from tourney_results tr, player p where tr.id_player = p.id_player and p.player_name = 'player1'))

how can I edid this so I can add more players? Or I have to use different expression filter? Basically I want to see my stats vs everyone I played except players I add myself.Thanks

[Flag_Hippo]

Code: Select all

tourney_hand_player_statistics.id_hand not in (SELECT ths.id_hand from tourney_hand_summary ths where ths.id_tourney in (select tr.id_tourney from tourney_results tr, player p where tr.id_player = p.id_player and (p.player_name = 'player1' or p.player_name = 'player2')))

You can add additional ORs as needed if you want to exclude data for more than two players.

[none888]

thanks, figured that out but missed extra ()