Hands against players without tag

[javitxu6]

Hello, I've seen that using this formula I can view hands against a specific player tag: tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, notes n WHERE thps.id_player = n.id_x AND (n.id_color = 2)).

How can I view hands against players who don't have a tag?

[javitxu6]

I would also like to know how to review hands involving two players with a specific tag. For example, if I want to see hands where two green-tagged players (tag 2) are at the table, how do I do it?