Check out example codes for "non equal join in oracle". It will help you in understanding the concepts better.

Code Example 1

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;

Learn ReactJs, React Native from akashmittal.com