not equi join code example

Example: non equal join in oracle

SELECT a.department_id, a.department_name, b.city
FROM departments a, locations b
WHERE b.location_id BETWEEN 1800 AND 2500
AND a.department_id < 30;