Set Membership

1. We use the in and not in operations for set membership.

   

2. Note that we can write the same query several ways in SQL.

3. We can also test for more than one attribute:

   

   This finds all customers who have a loan and an account at the SFU branch in yet another way.

4. Finding all customers who have a loan but not an account, we can use the not in operation.