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

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

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>

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.

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

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.

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

Is there any function in oracle similar like group_concat of mysql?

0 Answers  

What is rich query?

0 Answers  

How to connect ms access to oracle servers?

0 Answers  

Can you tell me how to add new column in existing views?how?How is possible?

0 Answers   FIS,

Is there a combination of "like" and "in" in sql?

0 Answers  

Can we create trigger on view in oracle?

1 Answers  

8. Display the client name and order date for all orders using the natural join keywords.

1 Answers   Wipro,

How to end the current transaction in oracle?

0 Answers  

How to put more than 1000 values into an oracle in clause?

0 Answers  

Explain the use of analyse option in exp command.

0 Answers