Hey guys,
how can I left join two tables together?
Example: I have one table called Users and another called skills which contains a user id value for each row. How can I now automatically show all skills in a multi-select field in the users table?
user table
user id | name
1 | Daniel
2 | Peter
skills table:
id | name | user
1 | Climbing | 1
2 | Running | 1
3 | Swimming | 2
Ideal outcome in user table
user id | name | skills
1 | Daniel | Climbing, Running
2 | Peter | Swimming
I am bit puzzled as this would be a simple left join SQL statement in a database. What am I missing here?