I would like to move the contents of one table into another table in the same db. This seems simple enough but I can't figure out how. Can someone point me in the right direction?
insert into NewTable(columns....)<BR>select (columns...) from OldTable<BR><BR><BR>
Yes, it is simple<BR><BR>insert into t2 select * from t1<BR><BR>but why?
I received some info in an access db and I imported it into sql but it created another table. So now I need to move the contents of the new table into the previous one.