title: Join master and detail tables as one table
body: <p>I have a master table and detail table like below</p>
  
  <p><strong>Master Table</strong></p>
  
  <pre><code>Id    code   Name
  -------------------
  1     00     qqq
  </code></pre>
  
  <p><strong>Detail Table</strong></p>
  
  <pre><code>Id    code   Name
  -------------------
  1     01     xyz
  1     02     pqr
  1     03     abc
  1     04     aaa
  </code></pre>
  
  <p>now I need the result like below</p>
  
  <p><strong>Result</strong></p>
  
  <pre><code>Id    code  Name
  -----------------
  1     00    qqq
  1     01    xyz
  1     02    pqr
  1     03    abc
  1     04    aaa
  </code></pre>
  
  <p><strong><em>I like to avoid UNION</em></strong> </p>
  
  <p>Thanks in advance :)</p>