Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4760👍, 0💬
Popular Posts:
How can we know the number of days between two given dates in PHP? Simple arithmetic: <?php $...
Is There Any XSD File to Validate Atom Feed Files? - RSS FAQs - Atom Feed Introduction and File Gene...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
Are risk constant through out the project ? * Never say that risk is high through out the project. R...