As I had no idea what Left Outer Joins are and the video lesson wasn’t enough for me to get a better grasp of what $lookup is all about, I did some digging around on SQL joins…
The MongoDB manual indicates that the $lookup stage is the equivalent of a Left Outer Join, but is it though?
It is my understanding that Left Outer Joins would actually return everything but the matching part (hence the “Outer”), while the $lookup stage looks more like a Left Join, returning both matching and non-matching elements from the “Left” table.
Maybe the MongoDB definition should be updated accordingly? It’s kind of confusing, especially for noobs like me
Again, I’m new to the subject, so if I’m wrong, I’d love to hear why
P.S.: For anyone willing to learn more about Joins, this is the best resource I was able to find: