I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc...
//my desired out come
employee_id | training_name
----------------------------
1 | training a
| training b
| training c
2 | training d
| training e
| training f
//my tables
employee table
id - primary key
name, age etc
employee_meta table
id
employee_id - foreign key from employee table
training name
I'm mainly selecting from the employee_meta table since there are multiple employee_ids. I just want to group them and not have it display over and over gain like this
employee_id | training_name
----------------------------
1 | training a
1 | training b
1 | training c
2 | training d
2 | training e
2 | training f