Post reply

update

  • April 10, 2003 at 8:45 am

    #80586

    I have a table wit 3 columns name,number,sal.I have one more table with name and email_address.i wanted to update the table 1 with email address of table2 by joining the column 'name'.Now how can i update tabel 1 by taking the values from table 2.Please help me out in this.

    Thank you

  • April 10, 2003 at 8:49 am

    #453727

    ?

    update Table1

    set Table1.Email = Table2.Email

    from Table1

    inner join Table2 on Table2.Name = Table1.name

    ?

  • April 10, 2003 at 1:39 pm

    #453786

    Thnak you,it works fine

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

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