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, 1696🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...