PDA

View Full Version : merging tables



james438
09-05-2007, 06: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:


table_new

ID, date1, article1, date2, article2


thanks :)