1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

Exclusive LEFT OUTER JOIN

An exclusive LEFT OUTER JOIN can be used to check for the presence of data in one table that is absent in another table. To create an exclusive LEFT OUTER JOIN the right query requires an IS NULL filter condition on the joining column.

Your sales manager is concerned that orders from French customers are declining. He wants you to compile a list of French customers that have not placed any orders so he can contact them.

Instructions 1/2

undefined XP
    1
    2
  • Add the joining operator between the Customers and Orders tables.
  • Add the joining columns from the Customers and Orders tables.