Database - Advanced SQL - Discussion

Discussion Forum : Advanced SQL - General Questions (Q.No. 2)
2.
What type of join is needed when you wish to return rows that do 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:
13 comments Page 2 of 2.

Pachi said:   9 years ago
Yes, option D is right one. Because also outer join return matching rows from both tables.

Sakhile said:   7 years ago
How it should be D? Please explain the answer to me.

Narasimhulu said:   6 years ago
The correct answer is C, Outer join returns the row having matching as well as non-matching values.


Post your comments here:

Your comments will be displayed after verification.