two-left-joins-broken.sql

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

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