java - database not updating for some reason -

this sql query not updating database, instead returning error. suggestions?

                    preparedstatement ps10 = con.preparestatement("update payroll_system.payslip set hours_worked = (select sum(hours) payroll_system.monthly_timesheet employeeid=?) employeeid=?");                     ps10.setstring(1, employee_id);                     ps10.setstring(2, employee_id);                     ps10.executeupdate(); 

monthly_timesheet table:

payslip table:

insert don't have clause   "insert payroll_system.payslip(expense_claims)   employeeid=?   select sum(expense) payroll_system.expense_master" 

eventually looking update?

or use

     "insert payroll_system.payslip(expense_claims)        select sum(expense) payroll_system.expense_mast" 

for update

 preparedstatement ps9 = con.preparestatement("update payroll_system.payslip       set expense_claims = (select sum(expense)       payroll_system.expense_master       employeeid=?) employeeid=?");       ps9.setstring(1, employee_id);      ps9.setstring(2, employee_id);      ps9.executeupdate();