Discussion Forum : Joins
Question - Which of the join operations do not preserve non matched tuples.
Options:
A .  Left outer join
B .  Right outer join
C .  Inner join
Answer: Option C


Inner joinINNER JOIN: Returns all rows when there is at least one match in BOTH tables



Was this answer helpful ?
Next Question
Submit Your Solution hear:

Your email address will not be published. Required fields are marked *