SELECT * FROM order_items LEFT OUTER JOIN orders ON order_items.order_id = orders.id
.--------.
| A .---+----.
| | ∩ | |
'----+---' B |
'--------'
- inner join =
∩ - left outer join =
A+∩ - right outer join =
∩+B - full outer join =
A+∩+B