title: Joining 2 selects results - whilst setting multiple allias
body: <p>Hi i am very new to this so sorry i if do not explain this well.</p>
  
  <p>I have 2 tables (delegate and module) both with column names such as "no" and "name" which are repeated </p>
  
  <p>What I am trying to acheive is get a result of the 4 tables .</p>
  
  <p>Heres my coding :</p>
  
  <pre><code>SELECT no AS del_no, name AS del_name
   FROM delegate
  
  Union ALL
  
   SELECT code AS module_code, name AS module_name
   FROM module;
  </code></pre>
  
  <p>My result is two columns with everything from module stacked underneath
  but what i really want is 4 colums from 2 different tables.</p>
  
  <p>I am unable to change the column names as this is in my requirements.</p>