Matching rows with BETWEEN instead of =

Question

Accepted Answer

A non-equi join uses a condition other than equality - here BETWEEN instead of =. Alice's salary 85000 falls in the Sr band (70000-999999); Bob's 55000 falls in Jr (0-69999). Non-equi joins work exactly like regular joins: every pair of rows where the ON condition is true produces an output row. Common uses include mapping salaries to pay grades, prices to discount tiers, or dates to fiscal periods.