Sorry to post a begginer question here... I am having difficulty with MySQL query here. do I use "join" or "sub-query" for things like this? I'm hoping that someone can show me how to write query for things like this.
I have following tables:
table: special
contains: special_id, special_name
table: keyword_2_speci al
contains: keyword_id, special_id
...