title: insert values from a column in Table A to Table B
body: <p>Table "content" has a primary key as ID</p>
  
  <pre><code>ID    name     languages_ID
  ============================
  33   lesson1     16
  34   lesson2     17
  
  </code></pre>
  
  <p>Table "content_progress" has a primary key as ID and foreign key as content_ID</p>
  
  <pre><code>
  ID   content_ID 
  ================
  1      33     
  2      33           
  3      33         
  4      34    
  
  </code></pre>
  
  <p>I added a column in table content_progress as languages_ID where its values should be filled from languages_ID column in content table where content.ID = content_progress.content_ID</p>
  
  <p>I have tried different SQL queries without desired result.</p>
  
  <pre><code>INSERT INTO content_progress (languages_ID) 
  SELECT
      languages_ID
  FROM
      content
  WHERE
      content.id = content_progress.content_ID;
  
  </code></pre>
  
  <pre><code>
  ID   content_ID   languages_ID
  ============================
  1      33            16
  2      33            16
  3      33            16
  4      34            17
  
  </code></pre>