Home » MCQs » SQL MCQs » SQL Statements and Clauses MCQs

In order to update one table using another table and join condition, which statement is used

25. In order to update one table using another table and join condition, which statement is used.

1. SQL UPDATE INTO
2. SQL UPDATE JOIN
3. SQL JOIN
4. SQL JOIN UPDATE

Answer: B) SQL UPDATE JOIN

Explanation:

SQL UPDATE JOIN is used to update one table using another table and join condition.