It looks like you're new here. If you want to get involved, click one of these buttons!
Can someone please clearly explain the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
Read this article for the best explanation.
Visual Representation of SQL Joins
Following is the cheat sheet.