JOIN in SQL is used to combine rows from two or more tables based on a related column.The main types of JOIN are as follows:
Using Venn Diagrams can make understanding much easier.
You can explore examples with diagrams and SQL statements on SQL Join...