SET operators
Set operators merge the results of two component queries into a single result. Queries containing set operators are known as Compound Queries.
Note: These SET operators can compare two sets of data only if the data are of the similar datatype.
The SET operators are discussed below.