Update Table

Discussion in 'Databases' started by Šatra, Mar 21, 2020.

0
  1. #1
    Hi, how to update derived table with data from base table?
    From table titles where I insert new row, I need update table current_title.
    Current_title is table derived from table title where column to_date=9999-01-01.
    Untitled6.png
     
    Šatra, Mar 21, 2020 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,830
    Likes Received:
    4,541
    Best Answers:
    123
    Trophy Points:
    665
    #2
    If by derived table you mean a "view" - it happens automatically.
     
    sarahk, Mar 21, 2020 IP
  3. Šatra

    Šatra Peon

    Messages:
    18
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    OK. I assumed it would happen, but I think in one case it was problem. I will check again. Thanks.
     
    Šatra, Mar 21, 2020 IP