SELECT users.name, likes.like FROM users JOIN likes ON users.id = likes.user_id;
Users
| ID | Name | |
|---|---|---|
| 1 | Patrik | |
| 2 | Albert | |
| 3 | Maria | |
| 4 | Darwin | |
| 5 | Elizabeth |
JOIN
| Name | Like |
|---|---|
| Maria | Stars |
| Patrik | Climbing |
| Patrik | Code |
| Darwin | Apples |
Likes
| User ID | Like | |
|---|---|---|
| 3 | Stars | |
| 1 | Climbing | |
| 1 | Code | |
| 6 | Rugby | |
| 4 | Apples |