Advertisement
Guest User

Untitled

a guest
Mar 21st, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. SELECT firstStud.name AS Player1,
  2. secondStud.name AS Player2,
  3. sports.name AS Sport
  4. FROM students AS firstStud
  5. JOIN students AS secondStud
  6. ON firstStud.id>SecondStud.id
  7. JOIN sports ON(firstStud.id IN(
  8. SELECT student_id
  9. FROM student_sport
  10. WHERE sportGroup_id IN(
  11. SELECT id
  12. FROM sportGroups
  13. WHERE sportGroups.sport_id=sports.id))
  14. AND (secondStud.id IN(
  15. SELECT student_id
  16. FROM student_sport
  17. WHERE sportGroup_id IN(
  18. SELECT id FROM sportGroups
  19. WHERE sportGroups.sport_id=sports.id))))
  20. WHERE firstStud.id IN(
  21. SELECT student_id
  22. FROM student_sport
  23. WHERE sportGroup_id IN(
  24. SELECT sportGroup_id
  25. FROM student_sport
  26. WHERE student_id=secondStud.id))
  27. ORDER BY sport;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement