| SELECT users.name, likes.like FROM users JOIN likes ON users.id = likes.user_id; Description » Hide description » INNER JOIN or just JOIN retrieves all users and likes that match each other ( where the id field in users matches a user_id in the likes table and vice versa ) |
| ID | Name |
|---|---|
| 1 | Patrik |
| 2 | Albert |
| 3 | Maria |
| 4 | Darwin |
| 5 | Elizabeth |
| Name | Like |
|---|---|
| Maria | Stars |
| Patrik | Climbing |
| Patrik | Code |
| Darwin | Apples |
| User ID | Like |
|---|---|
| 3 | Stars |
| 1 | Climbing |
| 1 | Code |
| 6 | Rugby |
| 4 | Apples |