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
- 18867 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to write a left outer join with the where clause in oracle?
What is bulk load in oracle?
How to rename a tablespace in oracle?
How to write a query with a right outer join in oracle?
What is ADDM Advisor in Oracle?
What are the original export and import utilities?
How to establish administrator authentication to the server?
Is there an oracle sql query that aggregates multiple rows into one row?
candidate key is subset of super key but not vice-verse explain
How to use null as conditions in oracle?
How to end the current transaction in oracle?
Please explain compound trigger in oracle?
Is truncate autocommit in oracle?
What is oracle sid?
