Left Join vs Left Outer Join in LookerML

  • 24 May 2022
  • 1 reply


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.


Thank you all for your help 😄


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