Part 69: Non-Equi Joins: Joining on Ranges & Inequalities

Joins are not restricted to equality (=). You can join on <, >, <=, >=, or BETWEEN.

1. Salary Grade Band Matching

SELECT 
  e.first_name,
  e.salary,
  g.grade_level
FROM employees e
JOIN salary_grades g 
  ON e.salary BETWEEN g.min_salary AND g.max_salary;

Key Takeaways

• Non-equi joins match rows based on numerical or temporal ranges.

In Part 70, we analyze NATURAL JOIN & USING Clause: Convenience vs Production Fragility!