merging tables

[james438]

I can rename the cols, but is there a way to create a new table from two where:

table1 has ID, date, article
table2 has ID, date, article

I would like to merge the two into one table that looks like the following:


table_new

ID, date1, article1, date2, article2


thanks :)