title: How to concatenate a table resulting from a query into another temporary table on a procedure stored on mysql?
body: <p>I have a temporary query, e.g : </p>
  
  <pre><code>CREATE TEMPORARY TABLE IF NOT EXISTS table4 AS (select * from table1)
  </code></pre>
  
  <p>and then, i have a another table resulting from a query, like: </p>
  
  <pre><code>select column from table2
  </code></pre>
  
  <p>what I would to do is to concatenated this column as a new column on the temparary table. Inner join would not work because they dont have a commom column
  This would be like the concatenate() on python with axis=0. </p>
  
  <p>I would appreciate any help</p>