These are used to get meaningful results from data stored in the table under different special conditions. Minus or set difference is an anti-join. How To Learn Sql Joins Learnsql Com SET operators are special type of operators which are used to combine the result of two queries. . Another Way of Finding Missing Results. Difference between Inner and Outer join in SQL. This article will cover all the set operations in SQL like Union Union All Intersect Minus with Examples. This is another one of those set operators that is truly meant to show you all rows from both queries. Example select SalesPersonID SalesQuota from SalesSalesPersonQuotaHistory UNION select SalesPersonID SalesQuota from SalesSalesPerson Output Union All operator. Lets get into learning about set. So well be using FULL JOIN throughout our SQL query. Set intersection is a join. Union and join are the two fundamental relational algebra opera...