Page 1 of 1

The difference between a LEFT JOIN and LEFT OUTER JOIN in SQL Server

Posted: Thu Jul 18, 2019 4:52 pm
by CWN
What is the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server?

I have seen both used in code, can anybody tell me the difference?

Re: The difference between a LEFT JOIN and LEFT OUTER JOIN in SQL Server

Posted: Thu Jul 18, 2019 4:55 pm
by Codebert
The Keyword 'OUTER' is optional, They are both the same.