SQL Multiple Join from 2 Tables to 1: A Better Approach Than UNION

Understanding the Pitfalls of Left Outer Joins in Hive: How to Optimize for Better Performance