WHERE vs ON clause filtering

Query Evaluation WHERE on Right Columns Consider this query that tries to find customers with high-value orders: Let's trace through what happens step by step: Filter Placement Effects Filter in ON Clause Now the evaluation changes dramatically: Comparing the Results Choosing Right Placement When to Use WHERE vs ON Both placements have valid use cases - it depends on your intent: Real-World Example Show all customers with their recent orders (last 30 days), including customers who haven't ordered recently: