MSSQL left join 與 left outer join 差別

  • 509
  • 0
  • 2017-11-28

無差別

The OUTER keyword is optional across most popular SQL distributions, which means there is absolutely no difference between a LEFT JOIN and a LEFT OUTER JOIN

在大多數流行的SQL分佈中,OUTER關鍵字是可選的,這意味著LEFT JOIN和LEFT OUTER JOIN之間絕對沒有區別

https://stackoverflow.com/questions/40086630/what-is-the-difference-between-left-join-and-left-outer-join