title: How can I add a column with its values from one table into another table in SQL?
body: <p>I know this question has been probably asked a million times, but I can't seem to find what I do.
  I have this table called Customer that only has 1 attribute (id) </p>
  
  <pre><code>      id
        ----
         1
         2
         3
         4
         5
  </code></pre>
  
  <p>And I have another table called Names that also has one attribute (name)</p>
  
  <pre><code>      name
        ----
         Tom
         Bob
         Sam
         Angel
         Joe
  </code></pre>
  
  <p>I want to add the column name from table Names to the table Customer so it turns out like this</p>
  
  <pre><code>       id  | name
        ------------
         1     Tom
         2     Bob
         3     Sam
         4     Angel
         5     Joe
  </code></pre>
  
  <p>How can I do this in sql?</p>