SELECT *
FROM students
         JOIN grades ON id = student_id;

--table.columncan be used to disambiguate column names:
SELECT *
FROM students
         JOIN grades ON students.id = grades.student_id

--Filtering columns in a join
SELECT name, course_id, grade
FROM students
         JOIN grades ON id = student_id;

--Filtered join (JOINwithWHERE)
SELECT name, course_id, grade
FROM students
         JOIN grades ON id = student_id
WHERE name = 'Bart';

--Poor query design
SELECT name, id, course_id, grade
FROM students
         JOIN grades ON id = 123
WHERE id = student_id;
--Improved query design - filter on WHERE not ON
SELECT name, id, course_id, grade
FROM students
         JOIN grades ON id = student_id
WHERE id = 123;

--Giving names to tables
SELECT s.name, g.*
FROM students s
         JOIN grades g ON s.id = g.student_id
WHERE g.grade