update
    ( 
    select t1.field1, 999 deact_status 
    from  
        schema.table1 t1
        inner join schema.table2 t2 on t1.id = t2.id
    where 
        t2.field2 = $emp_id
    ) 
set 
    field1 = deact_status