Which type of join returns all rows from one table and only those rows from a secondary table?

Options
- Inner join
- Self join
- Outer join
- Left join


CORRECT ANSWER : Outer join

Discussion Board
poorly worded question

Correct answers are:
Left join
and
Outer join

Why?
Because Left join = Left Outer join

The question does not specify: is it left or right join.
So both answers are proper, sadly :(

Outer join is a more general answer but "Left join" is proper also.


Marek 11-12-2020 10:30 AM

wording is confusing.

wording is confusing.

dave 03-14-2018 07:06 PM

Outer Join

Left Outer Join,
Right Outer Join and
Full Outer Join

Herny 07-1-2015 02:14 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement