There's nothing complicated here; everyone can see the teams' results. If you want to see who played against whom directly, please check who is scheduled to play against whom. Kostya was right; to make everything clear, you need to add 3 more tables to the general one or come up with some mega-complex but simple solution.
I'll try to come up with something clearer and simpler. You've become too lazy to bother.
Auto-translated
