SQL Inner-join with 3 tables?
You can do the following (I guessed on table fields,etc) SELECT s.studentname , s.studentid , s.studentdesc , h.hallname FROM students s INNER JOIN hallprefs hp on s.studentid = hp.studentid INNER JOIN halls h on hp.hallid = h.hallid Based on your request for multiple halls you could do it this way. You just join on your … Read more