scarydba.com
Database Fundamentals #21: Using the JOIN Operator, OUTER JOIN - Grant Fritchey
The OUTER JOIN returns one complete set of data and then the matching values from the other set. The syntax is basically the same as INNER JOIN but you have to include whether or not you’re dealing with a RIGHT or a LEFT JOIN. The OUTER word, just like the INNER key word, is not …