Post reply

how can I Update T1.f1 to T2.f2?

  • May 20, 2007 at 4:40 pm

    #70174

    Hi everybody,

    I want to update Table1 base on Table2, both table are the same, thay has ItemCode as Key, and T1.ItemLength should be updated to T2.ItemLength. Please help me on this matter.

  • May 20, 2007 at 7:56 pm

    #707714

    This is just a guess, make sure you test it before implementation :

    UPDATE T1 SET T1.ItemLength = T2.ItemLength FROM dbo.Table1 T1 INNER JOIN dbo.Table2 T2 ON T1.ItemCode = T2.ItemCode

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

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