title: Multiple column Union Query without duplicates
body: <p>I'm trying to write a <code>Union Query</code> with multiple columns from two different talbes (duh), but for some reason the second column of the second <code>Select</code> statement isn't showing up in the output.  I don't know if that painted the picture properly but here is my code:</p>
  
  <pre><code>Select empno, job
  From EMP
  Where job = 'MANAGER'
  Union
    Select empno, empstate
    From EMPADDRESS
    Where empstate = 'NY'
    Order By empno
  </code></pre>
  
  <p>The output looks like:</p>
  
  <pre><code>EMPNO   JOB
  4600    NY
  5300    MANAGER
  5300    NY
  7566    MANAGER
  7698    MANAGER
  7782    MANAGER
  7782    NY
  7934    NY
  9873    NY
  </code></pre>
  
  <p>Instead of 5300 and 7782 appearing twice, I thought <code>empstate</code> would appear next to <code>job</code> in the output.  For all other <code>empno</code>'s I thought the values in the fields would be <code>(null)</code>.  Am I not understanding <code>Unions</code> correctly, or is this how they are supposed to work?</p>
  
  <p>Thanks for any help in advance.</p>