full text search-query - SQL Server Forums

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.

All Forums

Site Related Forums

Article Discussion

full text search-query

Author

Topic

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2001-08-18 : 05:26:17

I am executing a query,which is returning duplicate records.
The resultset should consist of unique records.
The table structure and the data is as follow:

I have three table Group_Detail,Item_Master,Group_Feature.

GroupDetail
Group_Code(pk)
G0001
G0002
G0003

Item_Master
Group_Code(fk)
G0001
G0001
G0002

Group_Feature
Group_Code(fk)
G0001
G0001
G0002

The query in question:

Select distinct(G.Group_Code),G.Group_Title,G.Group_Main_Cat,
G.Group_Sub1,G.Group_Sub2,G.Group_Sub3,G.Group_Specification,
G.Group_Description,I.Item_Number,F.Group_Feature
from Group_Detail G,Item_Master I,Group_Feature F
where G.Group_Code=I.Group_Code and
G.Group_Code=F.Group_Code
and (contains(G.*,'quality')
or contains(I.*,'quality'))

I am using full text search to search for particular string
in all the three tables,columns included in the full index.
Thank you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources