Which type of JOIN is used to returns rows that do not have matching values?

DWQA Questions › Category: SQL › Which type of JOIN is used to returns rows that do not have matching values?

0 Vote Up Vote Down

<img alt='' src='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=48&r=g' srcset='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=96&r=g 2x' class='avatar avatar-48 photo' height='48' width='48' />

Editor Staff asked 11 months ago

Which type of JOIN is used to returns rows that do not have matching values?

Natural JOIN
Outer JOIN
EQUI JOIN
All of the above

Question Tags: SQL-Interview-Questions

1 Answers

0 Vote Up Vote Down

<img alt='' src='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=48&r=g' srcset='https://secure.gravatar.com/avatar/411b59d4f1b350c058deef204347460a?s=96&r=g 2x' class='avatar avatar-48 photo' height='48' width='48' />

Editor Staff answered 11 months ago

Answer:
B. Outer JOIN
Explanation:
OUTER JOIN is the only join that returned the unmatched rows in one or both tables. It can be classified into the following types:

LEFT JOIN that shows only the unmatched rows from the left table.
RIGHT JOIN that shows only the unmatched rows from the right table.
FULL OUTER JOIN that shows the unmatched rows from both tables.

EQUI JOIN shows records for equality or matching column(s) values of the relative tables.
A Natural join can only be performed if at least one common attribute exists between two relations (the attributes should be the same name and domain).