How to concatenate a table resulting from a query into another temporary table on a procedure stored on mysql ? : I have a temporary query, e.g : 

CREATE TEMPORARY TABLE IF NOT EXISTS table4 AS (select * from table1)

and then, i have a another table resulting from a query, like: 

select column from table2

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. 


I would appreciate any help