Not understanding from 4:20 on
So LEFT JOIN would return the values specific to the left table and the common ones. Right? but I can't make sense of the point you mentioned from 4:20 on. Could you please explain it further?
I would highly appreciate that.
Thanks for reaching out.
This is the famous Venn diagram. The result set of this join contains all records from the left table and the matching records from the right table. The result is 0 records from the right side, if there is no match.
Hope this helps.