Inner Joins
An inner join (sometimes called a simple join) is a join of two or more tables that returns only those rows that satisfy the join condition.
Outer Joins
An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.
By the definition of outer join we can clearly see that outer join return all row that satisfy the join condition plus other row that does not satisfy the join condition this will occur in case of Left Outer Join and Right Outer join .which is part of Outer Join.
Hence more apropriate ans is 1(Inner Join).
