56,679
社区成员
发帖
与我相关
我的任务
分享
select word from c_tag_word
where exists(
select 1 from c_movie_tag_director where aid= '1209' and tagid=c_tag_word.id
)
select distinct a.word
from c_tag_word a,c_movie_tag_director b
where a.id=b.tagid and b.aid= '1209'
CREATE TABLE `c_tag_word` (
`id` int(11) NOT NULL auto_increment,
`word` varchar(255) default NULL,
PRIMARY KEY (`id`),
KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `c_movie_tag_director` (
`aid` int(11) NOT NULL default '0',
`tagid` int(11) default NULL,
KEY `tagid` (`tagid`),
KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8