SQL JOIN
# Cross Join
Essentially a Cross Product
SELECT ∗
FROM courses, enrollment;
# Inner Join
SELECT column_name(s)
FROM tablel
INNER JOIN table2
ON table1_column_name = table2_column_name;
The table1_column.name = table2_column.name is the join condition.
The default JOIN Method
# Left Join
# Full Join
The full outer join which guarantees that all rows from each table will appear in the output.
# Natural Join
When the same column name match, the join the table