What are the benefits of using an UPDATE statement based on joins? (Choose all that apply.)
A. You can filter the rows to update based on information in related rows in other tables.
B. You can update multiple tables in one statement.
C. You can collect information from related rows in other tables to be used in the source expressions in the SET clause.
D. You can use data from multiple source rows that match one target row to update the data in the target row.
Answer:A
What are the benefits of using an UPDATE statement based on joins? (Choose all that apply.)
A. You can filter the rows to update based on information in related rows in other tables. B. You can update multiple tables in one statement. C. You can collect information from related rows in other tables to be used in the source expressions in the SET clause. D. You can use data from multiple source rows that match one target row to update the data in the target row.