Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 17152 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahima
Inner join: displays only matching record from 2 tables
Outer join:
Left outer join display all the records from 1st table even
if dont have matching record in 2nd table
rignt outer join display all the record from the 2nd table
even if there is not matching record in 1st table
| Is This Answer Correct ? | 40 Yes | 2 No |
Answer / 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 |
Answer / khalek
In Inner Join Only Matching Records come while in Outer Join
All Matching Records + All Non Matching Record(Based on
Outer Join type).
Outer join may be any type from following.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
You can see full detail at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / sunny
Inner join means it display all matching records in both tables depends upon condition....
Outer joins are three types..
1.left outer
2.right outer
3.full outer
In left outer:it will display all columns of right side table and matching columns of both tables.
In right outer:it will display all columns of left side table and matching columns of both tables.
In full outer:all matching non matching columns of both tables are displayed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashish sajwan
In Inner join the result is show only the matching columns which are common in both tables,In outer join the results show matched and unmatched columns from both tables
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / sripathi venkata ramesh
I am Sripathi Venkata Ramesh from Gudivada
Answer is below
Joins
a) Inner join or default join or Equi Join:
It selects all the matching aswellas non matching records
from both the tables.
b) Outer join: It selects all the matching
aswellas non matching records from both the tables
depending upon the join type.
1) Left outer join:
It selects all the records from the left table but only the
matching records from the right table.
2) Right outer join: It
selects all the records from the right table but only the
matching records from the left table.
3) Full outer join:
It’s a union of left and right outer join.
c) Cross join or Cartesian join: Every row
in the first table joins with every row in the second
table. It does not have any condition. It is also called as
a Cartesian join.
d) Self join: Joining a table by itself is
called Self join. Here we have to use alias table.
| Is This Answer Correct ? | 12 Yes | 24 No |
When can Hash Cluster used ?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How to install oracle odbc drivers?
What is the fastest query method to fetch data from the table?
How do I limit the number of rows returned by an oracle query after ordering?
How do we display rows from the table without duplicates?
what is null value?
How to create a new table in your schema?
20. Using a set operator, display the client number of all clients who have never placed an order.
Oracle General 
