Solved

Left Join vs Left Outer Join in LookerML

  • 24 May 2022
  • 1 reply
  • 113 views

Hello,

Is there any difference between Left Join and Left Outer Join in LookerML?

I'm a completely noob and I'm starting learning 😇

So, now I'm attending a training on Udemy, and the instructor mentioned that in LookerML, there are differences between those two lefts joins.

But as far as I know, the outer is optional and it doesn't affects the query.

https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server

 

Thank you all for your help 😄

icon

Best answer by Dawid 27 May 2022, 00:49

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +1

There is no difference. Left on its own doesn’t even appear on the list:

And it says LEFT OUTER just to be explicit