Results 1 to 4 of 4

Thread: Migrate Data

  1. #1
    Join Date
    Oct 2005
    Posts
    92

    Unanswered: Migrate Data

    Hi All,

    I have 2 table table A and Table B.

    The data in the colummns ID and Name is identical between these 2 tables.

    when the table A.ID = table B.ID and Table A.Name = Table B.Name then

    populate Table B.Complete Name with the values from Table A.Full Name.

    Can someone please help me out here,


    Table A
    ID Name Full Name
    1 kk kevin
    2 ok oklahoma
    3 pk penn state
    4 tx texas
    5 il illinois
    6 mi michigan
    7 cal california
    8 fl florida
    9 nc north carolina
    10 sc south carolina


    Table B
    ID Name complete Name
    1 kk
    2 ok
    3 pk
    4 tx
    5 il
    6 mi
    7 cal
    8 fl
    9 nc
    10 sc



    Thanks
    Pavan

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    We don't do homework.

    show us what you tried & the results
    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.

  3. #3
    Join Date
    Oct 2005
    Posts
    92

    Migrate Data

    This is resolved. Thank you

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >This is resolved. Thank you
    Posting solution so it can help others who search for similar problem is the Right Thing to do
    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
  •