Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 1)
1.
What type of join is needed when you wish to include rows that do not have matching values?
Discussion:
12 comments Page 1 of 2.
Ranjeeth raj R said:
1 decade ago
OUTER JOIN is the only joins which shows the unmatched rows
Vipul Javeri 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.
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.
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.
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.
Gganju said:
1 decade ago
Full Join: Retrieve all records from tables on both sides of the join condition regardless of whether records match the join criteria.
Niraj Kumar said:
1 decade ago
OUTER JOIN is the only joins which shows the unmatched rows.
Sweety said:
9 years ago
How outer join? explain me in detail.
Pranjli said:
9 years ago
Outer join shows the result of right outer join in which table of RHS is comparing with the LHS.
Sabina said:
9 years ago
Why not Equi-join?
Amit Ranjan said:
7 years ago
Out join will provide the unmatched rows of left and right table.
(1)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers