Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Write an Inner Join with the WHERE Clause
How To Write an Inner Join with the WHERE Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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 ......
2007-04-19, 5499👍, 0💬
Popular Posts:
What is the difference between strings and character arrays? A major difference is: string will have...
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...
What metrics will you look at in order to see the project is moving successfully? Most metric sets d...
How To Set Background to Transparent or Non-transparent? - CSS Tutorials - HTML Formatting Model: Bl...
What Is Paint Shop Pro? - PSP Tutorials - Fading Images to Background Colors with PSP Paint Shop Pro...