Inner Join with the WHERE Clause in Oracle

Q

How To Write an Inner Join with the WHERE Clause in Oracle?

✍: FYIcenter.com

A

If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example:

SQL> SELECT d.department_name, e.first_name, e.last_name 
  2  FROM departments d, employees e 
  3  WHERE d.manager_id = e.employee_id;

DEPARTMENT_NAME           FIRST_NAME           LAST_NAME
-------------------- -------------------- --------------
Administration            Jennifer             Whalen
Marketing                 Michael              Hartstein
Purchasing                Den                  Raphaely
Human Resources           Susan                Mavris
Shipping                  Adam                 Fripp
IT                        Alexander            Hunold
......

 

Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 165👍, 0💬