Menu
Community /Pin to ProfileBookmark
@NogDogFeb 14.2019 — #Use a join -- either inner join if you only want tasks that have tags, or left join if you want tasks even if they don't have tags.
@NogDogFeb 15.2019 — #
Because you're using a grouping function (and the same would hold true with a
How to select from intermediate table while also selecting from parent table.
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. ?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogFeb 14.2019 — #Use a join -- either inner join if you only want tasks that have tags, or left join if you want tasks even if they don't have tags.<i>
</i>select mytasks.task_name, mytags.tag_name
from mytasks
inner join mytasks_mytags as mm on mm.task_id = mytasks,task_id
inner join mytags on mm.tag_id = mytags.tag_id
-- where clause her if needed
order by mytasks.task_name -- or whatever makes sense
0
@NogDogFeb 15.2019 — #>@gautamz07#1601038 just not sure why i need two attributes supplied to GROUP BY I.E. mytasks.id , mytasks.task
Because you're using a grouping function (and the same would hold true with a
COUNT()