Collections:
Inner Join with the WHERE Clause in Oracle
How To Write an Inner Join with the WHERE Clause in Oracle?
✍: FYIcenter.com
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 ......
⇒ Left Outer Join with the WHERE Clause in Oracle
⇐ Query with a Full Outer Join in Oracle
2019-10-18, 1629🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...