Which command creates a table containing all rows that are in either or both of two tables?
A) UNION
B) SUBTRACT
C) JOIN
D) INTERSECT

Question

Quizplus · Accepted Answer

The command that creates a table containing all rows that are in either or both of two tables is UNION. UNION combines the results of two SELECT statements into a single table that includes all the rows that are in either or both of the tables.

Which Command Creates a Table Containing All Rows That Are