title: Merge two multi-column files based on one common column
body: <p>I have two tab-separated columns that I want to merge based on a common column.
  For example:</p>
  
  <p><strong>File 1:</strong></p>
  
  <pre><code>abandoning  0   V
  abandonment 0   N
  abandonments    0   N
  abandons    0   V
  abducted    0   V
  abduction   0   N
  </code></pre>
  
  <p><strong>File 2:</strong></p>
  
  <pre><code>abandonment
  abducted
  abduction
  abound
  abounds
  abundance
  abundant
  accessable
  </code></pre>
  
  <p>I want to merge these files into a third file that has an empty value if the information is not available.</p>
  
  <p><strong>File 3 (desired result):</strong></p>
  
  <pre><code>abandoning  0   V
  abandonment 0   N
  abandonments    0   N
  abandons    0   V
  abducted    0   V
  abduction   0   N
  abound
  abounds
  abundance
  abundant
  accessable
  </code></pre>
  
  <p>I have been looking around <a href="https://stackoverflow.com/questions/37757025/merge-two-files-based-on-one-column-awk">here</a> and <a href="https://stackoverflow.com/questions/4072180/merging-two-files-into-one-based-on-the-first-column">here</a> and <a href="https://stackoverflow.com/questions/27694948/merge-two-files-by-one-column">here</a>.
  So far, the closest thing that I have seen is this:</p>
  
  <pre><code>awk '{a[$1]=a[$1] FS $2} END {for (i in a) print i a[i]}' OrigFile.txt ToMerge.txt | sort &gt; Merged_Dict.txt 
  </code></pre>
  
  <p>However, the results do not include the third column information.
  The result that I obtain is:</p>
  
  <pre><code>abandoning 0
  abandonment 0 
  abandonments 0
  abandons 0
  abducted 0 
  abduction 0 
  abound 
  abounds 
  abundance 
  abundant 
  accessable 
  </code></pre>
  
  <p>Any hints as to where I am going wrong?</p>