Intermediate SQL
Joins SQL Lessons
Learn INNER, LEFT, RIGHT, FULL OUTER, SELF through focused tutorials and business-data examples.
Lessons in this category
SQL JoinsRead lesson SQL INNER JOINRead lesson SQL LEFT JOINRead lesson SQL RIGHT JOINRead lesson SQL FULL OUTER JOINRead lesson SQL CROSS JOINRead lesson SQL SELF JOINRead lesson SQL INNER vs OUTER JOINRead lesson SQL JOIN Using ONRead lesson SQL JOIN Using WHERERead lesson SQL ON vs WHERERead lesson SQL JOINs with Comparison OperatorsRead lesson SQL JOINs on Multiple KeysRead lesson SQL Multiple JOINsRead lesson SQL Joining Three or More TablesRead lesson SQL One-to-One RelationshipsRead lesson SQL One-to-Many RelationshipsRead lesson SQL Many-to-Many RelationshipsRead lesson SQL Primary Keys and Foreign KeysRead lesson SQL JOIN Duplicate RowsRead lesson SQL Non-Equi JOINRead lesson SQL Range JOINRead lesson SQL JOIN USINGRead lesson