Cacher is the code snippet organizer for pro developers

CREATE TABLE merged_table
SELECT table1.column1,table2.column2, table2.column3
FROM table1, table2
WHERE table1.column1=table2.column1