Results 1 to 2 of 2

Thread: Update SQL

  1. #1
    Join Date
    Sep 2008

    Unanswered: Update SQL


    How do I write update sql for following scenario.

    I have two tables TABLE A (col1,col2,col3) where col1 & col2 are keys and
    TABLE B (col1,col2,col4,col5) where col1 & col2 are keys .

    I have to update TABLE A col1,col2 values with TABLE B Col4,Col5 Values by
    join based on TABLE-A.Col1=TABLE-B.Col1 and TABLE-A.Col2=TABLE-B.Col2.

    Basically updating keys which we are joining on . If I use normal update will it lock the table?.

    Thanks for the help.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >If I use normal update will it lock the table?.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts