title: Use A Union Or A Join - What Is Faster
body: <p>I just wonder if you had a table and you unioned it would it be more efficent then using a join??</p>
  
  <p>I do know that the join creates more columns but this is more theoretical - Will the union need to do a nested loop scan of the other table like a join would have to?</p>