title: Update trigger select fields from same row
body: <p>i want an update trigger an a specific field. if that field value is changed i want to insert into a different table selecting all values of the row where update was made even though it was just for one field .</p>
  
  <p>example </p>
  
  <pre><code>id--------value1--------value2
  1-----------abc ----------efg
  </code></pre>
  
  <p>if value1 is updated to hij, i want to select id(1), value1(hij) and  value2(efg) and insert into a different table.</p>
  
  <p>i cannot do inserted.Id or inserted.value2 since both fields are not updated.</p>
  
  <p>NOTE:  please note only 1 field is updated, other field values are the same before and after, in my question i have just used an example, but in real life a record will be inserted and i am expected to insert the same values onto a different table. but upon insert the record wont be approved until later when approved field value is changed thats when i am expected the bring the values from other fields to different table.</p>