Difference between LEFT JOIN and LEFT OUTER JOIN in SQLServer

 Difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server

there is no difference between LEFT JOIN and LEFT OUTER JOIN.

SELECT *

FROM Customers C

  LEFT JOIN Orders O

    ON O.CustomerId = C.CustomerId







SELECT *

FROM Customers C

  LEFT OUTER JOIN Orders O

    ON O.CustomerId = C.CustomerId




CONCLUSION

From the above various examples we can see that there is absolutely NO DIFFERENCE between LEFT JOIN and LEFT OUTER JOIN. Even though both produces the same result and performance, I would prefer using LEFT OUTER JOIN instead of just LEFT JOIN. As it is more readable and leaves no ambiguity. Please share which one you use and reason for the same.