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.

Register to Read