Without proper DDL (create table) statements and sample data it is hard for us to understand and help you.

If I understand correct you have a view with data from 2 different tables. You want to alter the data in the view.

It is not possible to update two tables in a single statement. So you have to create two seperate update statement, one for each table. Specify the same value for "shift_id" in the WHERE clause of both update statements.