title: Compare two file columns (unsorted files)
body: <p><strong>Input File 1</strong></p>
  
  <pre><code>A1  123 AA
  B1  123 BB
  C2  44  CC1
  D1  12  DD1
  E1  11  EE1
  </code></pre>
  
  <p><strong>Input File 2</strong></p>
  
  <pre><code>A   sad21   1
  DD1 124f2   2
  CC  123tges 3
  BB  124sdf  4
  AA  1asrf   5
  </code></pre>
  
  <p><strong>Output File</strong></p>
  
  <pre><code>A1  123 AA  1asrf   5
  B1  123 BB  124sdf  4
  D1  12  DD1 124f2   2
  </code></pre>
  
  <p><strong>Making of Output file</strong></p>
  
  <p>We check 3rd column of Input File 1 and 1st Col of Input File 2. </p>
  
  <p>If they match , we print it in Output file. </p>
  
  <p><strong>Note :</strong></p>
  
  <p>The files are not sorted </p>
  
  <p>I tried : </p>
  
  <pre><code>join -t, A B | awk -F "\t"  'BEGIN{OFS="\t"} {if ($3==$4) print $1,$2,$3,$4,$6}'
  </code></pre>
  
  <p>But this doesnot work as files are unsorted. so the condition ($3==$4) won't work all the time. Please help .</p>