GitHub

all_joins_together.sql

-- LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table, and the matched records from the right table. -- The result is NULL from the right side if there is no match. -- RIGHT JOIN ...
GitHub

all_joins_together.txt

-- LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table, and the matched records from the right table. -- The result is NULL from the right side if there is no match. -- RIGHT JOIN ...