LEFT OUTER JOIN - SQLPerformance.com - powered by SQL Sentry

A left anti semi join is a query that returns rows from the left table that do not have matches in the right table. For example, all customers who have never placed an order. In this article, SQL Sentry's Aaron Bertrand walks through the various approache

sqlperformance.com