• LEFT JOIN shows all rows in the left-hand table, even if no match exists in the right
• SELECT firstname, surname, score FROM student LEFT JOIN assignment_score on student.id = assignment_score.studentid;
• this beats a standard JOIN by showing people who don't yet have scores
• Also beats multi-table SELECT in the same way
• Also called a LEFT OUTER JOIN

NEXT
PREVIOUS
Master Index