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 2 of 2.
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.
Ranjeeth raj R 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