In reality, SQL joins are easy to understand. But people usually seem to get confused between them. In this article, you can find a well known way to remember and understand visual explanation on how SQL joins relate to their corresponding names. Along with the visual representation, we had provide a sample query for each type of Join.
As shown in the above figure, when we left join Table A and B, related items of the Table A which resides in Table B will be shown in the result and rest of Table B will be left out.
When we right join Table B and A, matching keys of Table B in the Table A will be shown in the result.
Left Join With NULL
Right Join With NULL
Full Join With NULL