0:00
0% complete
LearnStep 1 of 2
SQL Joins
Learning Objectives
- •Understand join types
- •Write join queries
- •Use self-joins
Lesson Outline
LearnStep 1/2
SQL Joins
INNER JOIN
Returns only matching rows from both tables:
sql
LEFT JOIN (LEFT OUTER JOIN)
All rows from left table, matching from right:
sql
RIGHT JOIN
All rows from right table, matching from left.
FULL OUTER JOIN
All rows from both tables:
sql
CROSS JOIN
Cartesian product (all combinations):
sql
Self Join
sql