title: SQL query- probably wrong
body: <p>I am trying this query, but didn't work</p>
  
  <pre><code>INSERT INTO single_user (location_home.id_location_home ) 
  SELECT location_home.id_location_home 
  WHERE location_home.location = 'London'
  </code></pre>
  
  <p>Any help?</p>
  
  <p>error:</p>
  
  <pre><code>for the right syntax to use near 'WHERE location_home.location = 'London'' at line 3
  </code></pre>
  
  <p>thanks</p>