title: Merge and replace table id with name of two table SQL
body: <p>table customers:</p>
  
  <pre><code>+----+------------+
  | id | text       |
  +----+------------+
  | 33 | name1      | 
  | 34 | name2      | 
  | 35 | name3      | 
  | 36 | name4      | 
  +----+------------+
  </code></pre>
  
  <p>table orders:</p>
  
  <pre><code>+----+--------+------------+----------+
  | id |  cid   |  ordername |  colors  |
  +----+--------+------------+----------+
  |  8 |   34   |    name    |    5     |        
  +----+--------+------------+----------+
  </code></pre>
  
  <p>Is possible with one query have this result?</p>
  
  <pre><code>+----+--------+------------+----------+
  | id |  cid   |  ordername |  colors  |
  +----+--------+------------+----------+
  |  8 | name1  |    name    |    5     |        
  +----+--------+------------+----------+
  </code></pre>