How to produce pairs of students using SQL?
Among 30 students, one chooses three preferred partner. I have to show students that chose each other as partner. For example,
student_id = 1, partner_id = 2
student_id = 2, partner_id = 1. This should show on the webpage, “(student_id1, student_id2)”.