I am studying to learn how to build many to many into postgre sql but I am quite stuck.
The example I work on is the classic players / tournaments.
I've made my database this way:
And I've tried to write my views without success (because I can't put id_tournament into it):
I'm not necessarily for a complete solution: even a good hint to understand would be very welcome...