What the SQL?! JOIN me at UNION Station - Why, Scott, WHY?!?

What the SQL?! JOIN me at UNION Station - Why, Scott, WHY?!?