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?
Equi-join
Natural join
Outer join
All of the above.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
12 comments Page 2 of 2.

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.

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


Post your comments here:

Your comments will be displayed after verification.