Congratulations! We just learned about Set Operations in SQL. What can we generalize so far?
UNIONclause allows us to utilize information from multiple tables in our queries.
UNION ALLclause allows us to utilize information from multiple tables in our queries, including duplicate values.
INTERSECTis used to combine two
SELECTstatements, but returns rows only from the first
SELECTstatement that are identical to a row in the second
EXCEPTreturns distinct rows from the first
SELECTstatement that aren’t output by the second