Menu
I have the following tables inside my database:
“`
Table – mytags
| tag_id | tag_name |
| 1 | home |
| 2 | work |
TABLE – mytasks
| task_id | task_name |
| 14 | do my the dishes |
| 12 | Make presentation |
TABLE – mytasks_mytags
| mytag_id | mytask_id |
| 1 | 14 |
| 2 | 14 |
Now i would like to select the mytasks.task_id and mytasks.task_name and then i would like to retrive all the tag names with which this task is being associated with , this i can get from the mytasks_mytags table. Can somebody please guide me on how to go about doing this. ?