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

All topics about programming / development in T-SQL or other languages for SQL Server.
Post Reply
CWN
Posts: 5
Joined: Thu Jul 18, 2019 4:50 pm

Thu Jul 18, 2019 4:52 pm

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?
Codebert
Posts: 2
Joined: Tue Jul 02, 2019 7:22 pm

Thu Jul 18, 2019 4:55 pm

The Keyword 'OUTER' is optional, They are both the same.
Post Reply

Social Media