~/ learn/ comp-378/ cards/ Joins I: INNER JOIN, Equi-Join, Natural Join (and the Comma-Join)
1 of 6

Type the modern three-table inner join (the shape you will write on the exam):

Type the modern three-table inner join (the shape you will write on the exam):

Answer

SELECT st.name, c.code FROM registrations r JOIN students st ON st.student_id = r.student_id JOIN sections s ON s.section_id = r.section_id JOIN courses c ON c.course_id = s.course_id;

Each JOIN names a table and the ON condition that links it to what is already joined — three tables, two ON conditions reaching them from registrations.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/a0ac3490-1cb0-496f-9e0c-9bdb00816088/flashcard utf-8 LF