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 ......
2019-10-18, 843👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...