Left Join vs Left Outer Join in LookerML

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 ?

Solved Solved
0 1 540
1 ACCEPTED SOLUTION

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

441226fe-79ba-4a93-ab0a-86436f0b5841.png

And it says LEFT OUTER just to be explicit

54ef3db4-2f09-4f9c-9b8c-89fb445b44c2.png

View solution in original post

1 REPLY 1

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

441226fe-79ba-4a93-ab0a-86436f0b5841.png

And it says LEFT OUTER just to be explicit

54ef3db4-2f09-4f9c-9b8c-89fb445b44c2.png
Top Labels in this Space
Top Solution Authors