title: JOIN table rows vertically using UNION in SQL
body: <p>I have 2 tables Student and Staff, when I join them together using <code>UNION</code></p>
  
  <pre><code>SELECT STUNAME, STUGENDER,
     FROM STUDENT
     UNION
     SELECT STFNAME, STFGENDER
     FROM STAFF
     ORDER BY 1 ASC;
  </code></pre>
  
  <p>The name is mixing in the output, is there a way to separate them vertically like this, but still using UNION, I have assignment on this and still got stuck</p>
  
  <pre><code>STUNAME
  Alvin
  Jane
  STFNAME
  Lincoln
  Kate
  </code></pre>