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.
For example:
In my table tags I have: tag_id=3
l tag_des=music
In my table tag_media I have: tag_id=3
l media_id=5
(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