Database - Advanced SQL - Discussion

Discussion Forum : Advanced SQL - General Questions (Q.No. 1)
What type of join is needed when you wish to include rows that do not have matching values?
Natural join
Outer join
All of the above.
Answer: Option
No answer description is available. Let's discuss.
12 comments Page 1 of 2.

Upendra said:   3 years ago
The equijoin applied to two tables if both table have on common column.

Niranjan K C said:   4 years ago
Outer join is a combination of left and right outer join so we can retrive the unmatched records, by using suitable left or right outer join.

Amit Ranjan said:   5 years ago
Out join will provide the unmatched rows of left and right table.

Sabina said:   6 years ago
Why not Equi-join?

Pranjli said:   7 years ago
Outer join shows the result of right outer join in which table of RHS is comparing with the LHS.

Sweety said:   7 years ago
How outer join? explain me in detail.

Niraj Kumar said:   9 years ago
OUTER JOIN is the only joins which shows the unmatched rows.

Gganju said:   10 years ago
Full Join: Retrieve all records from tables on both sides of the join condition regardless of whether records match the join criteria.

Nibash panddey said:   1 decade ago
If you want unmatched rows you will have to use an outer join.

Right outer join gives unmatched rows from right side and left outer join gives unmatched rows from left side.

Full outer join (supported from oracle 9i onwards) will include unmatched rows from both sides.

Narinder kehar said:   1 decade ago
Outer join can be used because it provide right and left unmatched rows.

Post your comments here:

Your comments will be displayed after verification.