Union vs Intersect SQL
UNION operation
The UNION operation combines the results of two subqueries into a single result that comprises the rows that are returned by both queries.
INTERSECT operation
The INTERSECT operation combines the results of two queries into a single result that comprises all the rows common to both queries. Whereas a UNION operation is a logical OR, INTERSECT is a logical AND.