Skip to content

Instantly share code, notes, and snippets.

@mattm
Created November 1, 2017 18:13
Embed
What would you like to do?
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 |
+---------+-------+---------+---------+---------+---------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment