title: Joining two tables with different values in one column
body: <p>I am not an expert in sql.
  I have some data like below:</p>
  
  <pre><code>select column1,column2,cloumn3 from table1;
  
  ----------------------------------------------
  
  sub1  2207   43
  sub2  2207   45
  sub3  2207   47
  
  select column1,column2,cloumn3,attribute_name,attribute_value from table2;
  --------------------------------------------------------------------------
  
  sub1  2207   43  ENTITY_ID          VIJAY
  sub2  2207   45  ENTITY_ID          SHANKAR
  sub2  2207   45  ACTIVATION_DATE    01052018
  sub3  2207   47  ENTITY_ID          RISHI
  sub3  2207   47  ACTIVATION_DATE    01042018
  </code></pre>
  
  <p>I need an output like :</p>
  
  <pre><code>sub1  2207   43   VIJAY       NULL   
  sub2  2207   45   SHANKAR     01052018
  sub3  2207   47   RISHI       01042018
  </code></pre>
  
  <p>And this seems to be tough one for me. Could anybody help me to find the query.</p>