Multiple Tables
Expand your SQL skills by creating and manipulating databases with multiple related tables
StartKey Concepts
Review core concepts you need to learn to master this subject
Outer Join
Outer Join
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name = table2.column_name;
An outer join will combine rows from different tables even if the join condition is not met. In a LEFT JOIN
, every row in the left table is returned in the result set, and if the join condition is not met, then NULL
values are used to fill in the columns from the right table.
Multiple Tables
Lesson 1 of 1
What you'll create
Portfolio projects that showcase your new skills
How you'll master it
Stress-test your knowledge with quizzes that help commit syntax to memory