Lecture 3: CCIS2701 DB Design: RIGHT JOIN

inverse of LEFT JOIN is RIGHT JOIN: Show all records from right-hand table which don't have a match
select class.name, studentid from class_student RIGHT JOIN class ON class.id = class_student.classid;
Which to use, right or left? Whichever table has the unmatched entries you want to see
LEFT JOINs are preferred, as they result in code which is more portable between DBs
any guesses as to the other name of a RIGHT JOIN?