Post reply

update matching columns of another table

  • June 30, 2006 at 12:48 pm

    #60921

    Need help filling in these tables

    table 1       table 2

    a 1              -- 1   

    a 2             -- 1

    a 3             -- 2

    b  4              -- 3     etc

    b 5

    b 5

     

    update table 2 by inserting  the corresponding letters that match the numbers on table 1

    Thanks  for your help

     

     

     

  • June 30, 2006 at 12:54 pm

    #647063

    Update t2

    Set LetterColumn = t1.LetterColumn

    From Table2 As t2

    Inner Join Table1 As t1

      On (t1.NumberColumn = t2.NumberCOlumn)

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply