In this excerpt from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, John L. Viescas and Michael J. Hernandez discuss the LEFT OUTER JOIN vs. the RIGHT OUTER JOIN and offer ...

Even though the intention is an outer join that keeps all rows from A, rows missing in B are disappearing. First, I want to ...