title: Assemble two sql queries result that have nothing in common
body: <p>How can I insert values into a table if these values are retrieved from two different tables that have nothing in common?
  From the first table i will retrieve (SELECT) only one value and the remaining values will be retrieved from the second table.</p>
  
  <p>I want to retrieve the first value from the first table and the remaining values from the second table and then return all these into the INSERT that i want to perform.</p>
  
  <p>EDIT : Here an example of the structure :</p>
  
  <p>Here are the tables.  I hope this is clear. Feel free to ask me for more details.</p>
  
  <pre><code>CREATE TABLE table1
  (id int,  productName  varchar(7),  description  varchar(55))
  ;
  
  CREATE TABLE table2
  (id int,  productName  varchar(7))
  ;
  </code></pre>
  
  <p>This is what I have tried:</p>
  
  <pre><code>INSERT INTO table2 (`id`,`productName`)
  SELECT COALESCE(Max(id + 1), 0) 
  FROM table2 
  UNION 
  SELECT productName 
  FROM table1
  </code></pre>
  
  <p>This will get me an error obviously but at least this is more clearer I hope.</p>