December 21, 2009 at 5:18 pm
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:
December 21, 2009 at 7:33 pm
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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply