OMG, this is the clearest explanation I've ever read of what a LEFT and RIGHT OUTER JOIN are. Epiphany!! Thank you.