View Full Version : merging tables

09-05-2007, 05:24 AM
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:


ID, date1, article1, date2, article2

thanks :)