Set Operations

1. SQL has the set operations union, intersect and minus. Some examples:
   1. Find all customers having an account at the SFU branch.

      

   2. Find all customers having a loan at the SFU branch.

      

   3. Find all customers having a loan, an account, or both at SFU branch.

      

   4. Find customers having a loan and an account at the branch.

      

   5. Find customers having an account, but not a loan at the branch.

      

2. Some additional details:
   • union eliminates duplicates, being a set operation.
   • Not all implementations of SQL have these set operations.
   • It is possible to express these queries using other operations.