title: INSERT INTO (SELECT & VALUES) TOGETHER
body: <p>I'm trying to <code>INSERT INTO</code> a table, and I know 2 ways:</p>
  
  <p>Adding rows as values:</p>
  
  <pre><code>INSERT INTO db_example.tab_example (id,name,surname,group)
  VALUES ('','Tom','Hanks','1');
  </code></pre>
  
  <p>or from another table:</p>
  
  <pre><code>INSERT INTO db_example.tab_example (id,name,surname)
  SELECT ID,first_name,last_name FROM db_contacts.tab_mygroup;
  </code></pre>
  
  <p>but what if I want to insert some values from another table (the second way), and some values manually like a default value (the first way).</p>
  
  <p>here's my try (it didn't work):</p>
  
  <pre><code>INSERT INTO db_example.tab_example (id,name,surname,group)
  VALUES (
   SELECT ID FROM db_contacts.tab_mygroup,
   SELECT first_name FROM db_contacts.tab_mygroup,
   SELECT last_name FROM db_contacts.tab_mygroup,
   '1'
  );
  </code></pre>
  
  <p>I thought of creating a <code>VIEW</code>table and it might solve the problem, but I thought there might be someway to add both together.</p>
  
  <p>Thank you guys! I hope I described well what I need :)</p>