请问一个模糊嵌套查询的写法

请教一个模糊嵌套查询的写法。
表book：
bookid
title 标题
content 内容

表titelkey
titelkey标题关键词

现在要将标题中含有任一标题关键词的bookid查询出来，该怎么写，谢谢~

[解决办法]

SQL code

goif OBJECT_ID('book')is not nulldrop table bookgocreate table book(bookid varchar(4),title varchar(20),content nvarchar(20))goinsert bookselect '1001','javaee',null union allselect '1002','sql server',null union allselect '1003','wp7',null union allselect '1004','android 2.3.4',null union allselect '1005','linux os',null union allselect '1006','android 2.3.0',null union allselect '1007','windows os',nullgoif OBJECT_ID('titelkey') is not nulldrop table titelkeygocreate table titelkey(tk varchar(10))goinsert titelkeyselect 'java' union allselect 'os' union allselect 'wp'select *,COUNT(1)over(partition by tk) as times--每个关键词有多少本相关bookfrom(select bookid,title,tk from bookcross join titelkeywhere CHARINDEX(tk,title)>0)t/*能看懂下面的结果吧bookid    title    tk    times------------------------------1001    javaee    java    11005    linux os    os    21007    windows os    os    21003    wp7    wp    1*/
[解决办法]
全文索引查找。