Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 19134 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vamsi krishna
INNER JOIN DISPLAYS ONLY THE RECORDS WHICH ARE SATISFYING
THE JOINING CONDITION,WHERE AS IN AN OUTER JOIN IT DISPLAYS
THE RECORDS WHICH ARE SATISFYING THE CONDITION AND ALSO
WHICH ARE NOT SATIFYING THE CONDITION ALSO.
FOR EXAMPLE TAKE EMP AND DEPT TABLE.
INNER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP INNER
JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO)
OUTER JOIN QUERY:
SELECT EMPNO,ENAME,SAL,DEPT.DEPTNO,DNAME,LOC FROM EMP RIGHT
OUTER JOIN DEPT ON(EMP.DEPTNO=DEPT.DEPTNO).
IN INNER JOIN IT DISPLAYS ONLY 10,20 & 30 DEPARTMENTS.
IN OUTER JOIN IT DISPLAYS 10,20,30 AND 40 DEPARTMENTS.
TAKE DEFAULT TABLES FOR EXECUTION
| Is This Answer Correct ? | 39 Yes | 4 No |
Post New Answer View All Answers
What are the different editions of oracle?
How do we display rows from the table without duplicates?
How to select some rows from a table in oracle?
How do we create privileges in oracle?
What is MTTR advisor in Oracle?
Give the various rollback segment states.
How to add a new column to an existing table with a default value?
How to use windows user to connect to the server?
Explain the use of constraints option in exp command.
How to rename a tablespace in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
How do we get field detail of a table?
How to grant create session privilege to a user in oracle?
What are the attributes that are found in a cursor?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
