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 |