We can write the trigger for first table on data manupulation. we will write the query to update second table in trigger. whenever we will update the  table  then trigger will fire to update the second table . This is one solution through which we can manipulate the data from one table to another.