left-join-broken.sql

SELECT *
FROM users
LEFT JOIN posts ON posts.user_id = users.user_id

+---------+-------+---------+---------+
| user_id | name  | post_id | user_id |
+---------+-------+---------+---------+
|       1 | Matt  | 1       | 1       |
|       1 | Matt  | 2       | 1       |
|       1 | Matt  | 3       | 1       |
|       2 | Simon | 4       | 2       |
|       2 | Simon | 5       | 2       |
|       3 | Jen   | NULL    | NULL    |
+---------+-------+---------+---------+