Listing 2: Join Query That Returns Customers Who Placed No Orders
SELECT C.*
FROM Customers AS C
  LEFT OUTER JOIN Orders AS O
    ON C.custid = O.custid
WHERE O.custid IS NULL