Loading lesson path
Concept visual
Start at both ends
Formula
operator is used to combine the result - set of two or morestatements.
operator includes all rows from each statement, including any duplicates.
statement within
must have the same number of columns The columns must also have similar data types
statement must also be in the same order
column_name(s)
table1
column_name(s)
table2
;Formula
The column names in the result - set are usually equal to the column names in the firststatement.
Below is a selection from the "Customers" table: