synchronizing the table with another table

• arunagulla

  Grasshopper

  Points: 13

  More actions

  July 23, 2008 at 2:29 am

  #94317

  I have a table with userId and other columns with all the values in the columns. I created a new table with primary key of userId column and some other columns. Now I have to synchronize the new table with the old table depending on the userId column.

  Could any one please tell me How to do this.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 23, 2008 at 7:43 am

  #847036

  I guess it depends on what data you are trying to move.

  Most likely, a simple "Insert...Select" will do it. But I would need more information (possibly table structure), to say for sure.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon