Relational Databases
“JOIN” is an SQL keyword used to query data from two or more related tables.
Inner join (or just Join)
The most frequently used clause is INNER JOIN. This produces a set of records which match in both the user and course tables.
Left join
This produces a set of records which matches every entry in the left table regardless of any matching entry in the right table.