12 SELECT * FROM order_items \
13 LEFT OUTER JOIN orders \
14 ON order_items.order_id = orders.id
18 Joins are typically added to `SELECT` statements to add more columns and records.
23 SELECT * FROM `A` INNER JOIN `B`
34 {: .-box-chars.-setup}
39 | Left outer join | `A` + `∩` |
40 | Right outer join | `∩` + `B` |
41 | Full outer join | `A` + `∩` + `B` |