update by joining table

• rajesha

  SSC-Addicted

  Points: 412

  More actions

  January 7, 2003 at 7:29 am

  #101344

  i have 2 tables

  in table1 fields are sno,phonenum,name

  in table2 fields are sno and phonenum

  i want to update phonenum in table1 with phonenum in table2 curresponding to sno

  how can i write a single query to update phonenum in table1 by joins or anyother way

  can anybody help me

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  January 7, 2003 at 7:40 am

  #445712

  Try: -

  update t1

  set

  t1.phonenum = t2.phonenum

  from

  table1 t1 inner join table2 t2 on t1.sno = t2.sno

  Regards,

  Andy Jones

  .