Post reply

Procedure/steps to update one table if another is changed

  • April 27, 2007 at 6:31 am

    #70019

    Have two tables

    table1

    name ssid location network

    table2

    name ssid location network firstname lastname

    SSID is unique on both tables.When name,location or network are modified on table1 I would like table2 to be updated with the new values.(Only table 1 changes).

    this could be on a needed bases or right away

    Your input is appreciated

    Mike

  • April 27, 2007 at 7:37 am

    #702918

    Hi,

    I would create a trigger on table1, which updates table2 using the data from the inserted table.

    Inserted & Deleted tables are only available inside a trigger, for an update transaction contain the data for before and after the update.

    Regards,

     

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

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