| Inner join | Outer join |
|---|---|
| Only matching rows | Matching plus unmatched rows |
SELECT * FROM a INNER JOIN b ON a.id = b.a_id;
Make this comfortable
Inner Join vs Outer Join
Compare join types with examples and a side-by-side table.
dbms
sql
Compare join types with examples and a side-by-side table.
| Inner join | Outer join |
|---|---|
| Only matching rows | Matching plus unmatched rows |
SELECT * FROM a INNER JOIN b ON a.id = b.a_id;