The UNION clause is used to:
A) combine the output from multiple queries into a single result table.
B) join two tables together to form one table.
C) find all rows that do not match in two tables.
D) none of the above.

Question

Quizplus · Accepted Answer

The UNION clause is used to combine the output from multiple queries into a single result table. It is often used to combine data from different tables that have the same columns. JOIN is used to combine rows from two or more tables based on a related column between them, and finding all rows that do not match is done using the LEFT JOIN or RIGHT JOIN clauses. Therefore, option A is the best choice for the given question.

The UNION Clause Is Used To