In SQL, which type of JOIN returns all rows from at least one of the tables mentioned from the FROM clause, providing those rows meet any WHERE or HAVING search conditions?

In SQL, which type of JOIN returns all rows from at least one of the tables mentioned from the FROM clause, providing those rows meet any WHERE or HAVING search conditions?

• Table Join
• Outer Join
• Comparison Join
• Inner Join 

 

EXPLANATION

Inner joins return rows only when there is at least one row from both tables that matches the join condition. Inner joins eliminate the rows that do not match with a row from the other table. Outer joins, however, return all rows from at least one of the tables or views mentioned in
the FROM clause, as long as those rows meet any WHERE or HAVING search conditions. All rows are retrieved from the left table referenced with a left outer join, and all rows from the right table referenced in a right outer join. All rows from both tables are returned in a full outer join.

SOURCE

https://technet.microsoft.com/en-us/library/ms187518(v=sql.105).aspx