table merging

rangerbud249

Active member
Joined
Aug 18, 2004
Messages
27
Programming Experience
Beginner
I have two tables each with a date field. I have to combine these two tables and sort on the date. I want the date from each table to be on the same column though, not in seperate columns.

Thanks for the help
Rock *
 

Tarik

Active member
Joined
Apr 16, 2005
Messages
41
Location
Egypt-Alexandria
Programming Experience
3-5
Suppose you have table1 and table2 and you want to move column mdate from table1 into table2 in the field called mdate2
VB.NET:
Insert into table2(mdate2)
select mdate from table1
 
Top Bottom