Find rows with no match in another table

LEFT JOIN and keep the rows where the right side is NULL.

More SQL recipes

• Find duplicate values
• Get the top N rows per query
• Calculate a running total
• Pivot values into columns with CASE
• Count rows per group