title: Insert into with select and group by
body: <p>i try to do a <code>INSERT INTO</code> with select and group by, like this:</p>
  
  <pre><code>INSERT INTO client(name, age, last_name, id_city)
  select l.name_client, l.age_client, l.last_name, l.id_city
  from list_request l 
  inner join product pd
    on l.id = pd.id_list_request;
  </code></pre>
  
  <p>When i run it, 4 results appear, repeated, but i only need one.</p>
  
  <p>What can i do to solve this, i try to use GROUP BY, but is not work, or i don't know how to use it.</p>
  
  <p>Edit: sorry, I forgot 2 columns, but I just need to group by name and age.</p>