Suppose
if you have table-A (Left Table) & Table-B(Right Table).
Left Join: Merging the values of Table-A & Table-B of common fields between them & also other values of Left Table (Table-A).
Right Join: Merging the values of Table-A & Table-B of common fields between them & also other values of Right Table (Table-B).
Left Join: Merging the values of Table-A & Table-B of common fields between them & also other values of Left Table (Table-A).
Right Join: Merging the values of Table-A & Table-B of common fields between them & also other values of Right Table (Table-B).