I have a problem with my database or query. I've three tables, one for videos, another for tags of the videos and other for the tags descriptions and theirs id.
I want to access to the TAG_DES.
In my table tags I have:
In my table tag_media I have:
(it means that the video with id=5 have a tag with id=3, that is music)
So I want to get
tag_des (music for example) where
media_id=5 by using te tag_id...
This is the image of the tables
This is the query that I have, but it returns me null i dont know why:
SELECT t.tag_des FROM media_thumbnail AS m INNER JOIN tag_media as tm ON tm.media_id=5 INNER JOIN tags AS t ON tm.tag_id=5