Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chava_sree
Yak Posting Veteran
56 Posts |
 Posted - 2008-08-11 : 20:11:46
|
| Hi all,Here is my Problem am facing,I've two tables 1) User (user_id, username)2) CustomPPT (cp_id, User_id,Desc,Title)My Requirement is to create a FullText Catalog on these two tables using the Index, and be able to search on Both (for ex: John Cisco) will be searched thru both the tables and gives you a match. but for my case "User" has already a FullText Catalog Created SEarching just for User names for some other Routine,then I've no Choice to Create a "Customppt" FullText Index Inner JOin Usertable and do a Union of these two Catalogs to get search Results.but am not getting the results as expected when i searched through a combination of words like "John Cisco", means "John Cisco" must exist in One FullText Catalog, where each word belongs to different FullText Catalogs.any idea.. See my Query below.SELECT * FROM CUSTOMPPT INNER JOIN CONTAINSTABLE(CUSTOMPPT, @ss) FPT ON CUSTOMPPT.CP_ID = FPT.KEYUNION ALLSELECT * FROM CUSTOMPPT INNER JOIN CONTAINSTABLE(USER, @ss) FPT ON CUSTOMPPT.USER_ID = FPT.KEYany help or suggestion is greatly appreciated.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-11 : 23:17:19
|
| Don't know how you can do that, since table CustomPPT doesn't have username column at all. |
 |
|
|
|
|
|
|
|
FullText Searching