Combine (horizontally) two MySQL tables into one based on a common column of data from each table.
The original two tables are not altered but a new table is created with the results.