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.
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.
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.
Niranjan K C said:
7 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.
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.
Pranjli said:
9 years ago
Outer join shows the result of right outer join in which table of RHS is comparing with the LHS.
Narinder kehar said:
1 decade ago
Outer join can be used because it provide right and left unmatched rows.
Upendra said:
5 years ago
The equijoin applied to two tables if both table have on common column.
Amit Ranjan said:
7 years ago
Out join will provide the unmatched rows of left and right table.
(1)
Ranjeeth raj R said:
1 decade ago
OUTER JOIN is the only joins which shows the unmatched rows
Niraj Kumar said:
1 decade ago
OUTER JOIN is the only joins which shows the unmatched rows.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers