I showed you how to tune an Update statement with a simple subquery in my last blog, a more complex update statement will be discussed in the following: update emp_subsidiary set emp_name=concat(‘Sub ‘,emp_name) where emp_id in (SELECT EMP_ID FROM EMPLOYEE,DEPARTMENT