left join and left outer join

Question

What is the difference between LEFT JOIN and LEFT OUTER JOIN?

Answer 1

1. INNER JOIN - fetches data if present in both the tables.

2. OUTER JOIN are of 3 types:

   1. LEFT OUTER JOIN - fetches data if present in the left table.
   2. RIGHT OUTER JOIN - fetches data if present in the right table.
   3. FULL OUTER JOIN - fetches data if present in either of the two tables.

3. CROSS JOIN, as the name suggests, does [n X m] that joins everything to everything.
    

Answer 2

Both versions of the syntax will produce the exact same result. Some do recommend including outer in a LEFT JOIN