Tell us what’s happening:
I’ve tried using:
SELECT * FROM students LEFT JOIN majors ON students.major_id = majors.major_id;
since they want me to show all students (so students first) but only specific majors (so majors second)
Your code so far
They want me to do it the other way around, with majors first, then students.
My question is: does it matter?
I’m looking at both tables, and they have the same data. My logic was to show all the students first, so I used LEFT JOIN; am I missing something subtle here, or am I overthinking it?
Just want to make sure I understand the commands.
Thanks
Your browser information:
User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Edg/121.0.0.0
Challenge Information:
Learn SQL by Building a Student Database: Part 2 - Build a Student Database: Part 2