non equal join in oracle
snippet in sql

non equal join in oracle

user4214

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;