title: SQL view join data in the same table but different row
body: <p>Say I have single db2 table <strong>FACT_VEHICLE</strong> with the following rows:</p>
  
  <hr>
  
  <pre><code>FACT_VEHICLE
  ___________________________________________________________
  **ID**    |**COLOR**   |**ADDITIONAL_INFO**
  ___________________________________________________________
  1         |BLUE        |
  ___________________________________________________________
  2         |RED         |1
  </code></pre>
  
  <p>From this table, I'm creating a view that should look like this:</p>
  
  <pre><code>VIEW_VEHICLE
  ____________________________________________________________
  **ID**    |**COLOR_1** |**COLOR_2**
  ____________________________________________________________
  1         |BLUE        |
  ____________________________________________________________
  2         |RED         |BLUE
  </code></pre>
  
  <p>To display the content of the <em>COLOR_2</em> row in the view, I've thought about doing a subselect like this:</p>
  
  <pre><code>SELECT
  f.ID AS ID,
  f.COLOR AS COLOR_1,
  f2.COLOR AS COLOR_2
  FROM FACT_VEHICLE f JOIN FACT_VEHICLE f2 ON f2.ID = f.ADDITIONAL_INFO;
  </code></pre>
  
  <p>Is this the most performant way to do this?</p>