I am trying to join two tables so that the data stored in rows of table 2 are joined as columns onto table 1.
work_tickets:
wt_id problem
1 TV
2 Lights
3 TV
wt_follow_up
follow_up_id wt_id description
1 1 not at home
2 2 changed bulb
3 1 fixed tv
Currently:
wt_id problem description
1 TV not at home
1 TV fixed tv
2 Lights changed bulb
3
desired:
wt_id problem follow_up1 follow_up2
1 TV not at home fixed tv
2 Lights changed bulb
3 TV
I've look at SQL multiple rows as columns (optimizing) and MySQL - Rows to Columns, but these are not based on text data.