equi and non equi join in oracle 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;
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;