which of the following statements is true in regards to the update statement

Consider the following TSQL update statement: UPDATE EMPLOYEES SET EMPLOYEES.SALARY = PAYROLL.SALARY FROM PAYROLL, EMPLOYEES WHERE EMPLOYEES.ID = PAYROLL.EMP-.ID Which of the following statements is TRUE in regards to the update statement? A O This statement will result in an error. B This statement will update both the EMPLOYEES and PAYROLL tables. C O This statement will never update any rows. D This statement will update the SALARY column in the EMPLOYEES table