What is left join, right join? (Learn all joins)

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).