Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT firstStud.name AS Player1,
- secondStud.name AS Player2,
- sports.name AS Sport
- FROM students AS firstStud
- JOIN students AS secondStud
- ON firstStud.id>SecondStud.id
- JOIN sports ON(firstStud.id IN(
- SELECT student_id
- FROM student_sport
- WHERE sportGroup_id IN(
- SELECT id
- FROM sportGroups
- WHERE sportGroups.sport_id=sports.id))
- AND (secondStud.id IN(
- SELECT student_id
- FROM student_sport
- WHERE sportGroup_id IN(
- SELECT id FROM sportGroups
- WHERE sportGroups.sport_id=sports.id))))
- WHERE firstStud.id IN(
- SELECT student_id
- FROM student_sport
- WHERE sportGroup_id IN(
- SELECT sportGroup_id
- FROM student_sport
- WHERE student_id=secondStud.id))
- ORDER BY sport;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement