update from

• QML

  Old Hand

  Points: 381

  More actions

  July 14, 2008 at 2:56 pm

  #193900

  What is the different this queries ?

  update table1

  set table1.a = table2.b

  from table2

  where table1.c=table2.c

  -----------------------------

  update table1

  set table1.a = table2.b

  from table1 t1 inner join table2 t2

  on t1.c = t2.c

  thanks?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 14, 2008 at 3:02 pm

  #842710

  The wording. They should do the same thing.

  - 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

• Victor Carlos

  SSC-Addicted

  Points: 430

  More actions

  July 14, 2008 at 3:09 pm

  #842716

  the result is the same