Check out example codes for "equi joins in oracle". It will help you in understanding the concepts better.

Code Example 1

SELECT first_name, job_id, departments.department_id, department_name
FROM employees, departments
WHERE employees.department_id = departments.department_id
ORDER BY last_name, job_id;

Code Example 2

Learn ReactJs, React Native from akashmittal.com