Menu
Community /Pin to ProfileBookmark
@NogDogJan 31.2019 — #That's what "joins" are for.
If it's possible for there to be no tags associated with a task but you want to retrieve it anyway, then change the "inner join" instances to "left join".
How do i query 2 tables at the same time
I have the following tables like below:
“`
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 |
Given that i have the id of the mytask table EG. “14” , now i given that i would like to select the mytasks_mytags.mytag_id that are associated with the mytasks_mytags.mytask_id I.E. “14” and then get the mytasks.task_name , how do i merge this inside one
query in mysql ?
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJan 31.2019 — #That's what "joins" are for.<i>
</i>select mytasks.task_name, mytags.tag_name
from mytasks
inner join mytasks_mytags as mm on mytasks.task_id = mm.mytask_id
inner join mytags on mytags.mytag_id = mm.mytag_id
where mytasks.task_id = 14
If it's possible for there to be no tags associated with a task but you want to retrieve it anyway, then change the "inner join" instances to "left join".