Looking at someone elses code

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  December 21, 2009 at 5:18 pm

  #1095189

  CirquedeSQLeil (12/21/2009)

  ---

  Lynn Pettis (12/21/2009)

  ---

  Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you sure you copied all the code into your post?

  Err...That was Jeff.

  Jason is blocked from seeing the pic.

  Yes, I know. Problem was I was seeing your name as i was typing. I didn't have the other tab scrolled up far enough. Sorry Jeff!. :blush:

• Jeffrey Williams

  SSC Guru

  Points: 89773

  More actions

  December 21, 2009 at 7:33 pm

  #1095209

  Lynn Pettis (12/21/2009)

  ---

  CirquedeSQLeil (12/21/2009)

  ---

  Lynn Pettis (12/21/2009)

  ---

  Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). Are you sure you copied all the code into your post?

  Err...That was Jeff.

  Jason is blocked from seeing the pic.

  Yes, I know. Problem was I was seeing your name as i was typing. I didn't have the other tab scrolled up far enough. Sorry Jeff!. :blush:

  No problem - I answer to all sorts of names, most can't be posted here though :hehe:

  Jeffrey Williams
  Problems are opportunities brilliantly disguised as insurmountable obstacles.

  How to post questions to get better answers faster
  Managing Transaction Logs