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 ...
Here's what I need to do. Again, I'm working with a data structure that I have no control over. In the simplest form, I am joining two tables on two values. However, the second value isn't identical.