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 |
|
Eliza
Starting Member
2 Posts |
 Posted - 2002-10-24 : 16:20:25
|
| I need to be able to run a full text search on two sql tables in my database. They are related. I have added both tables to the Full Text Catalog. But when I run the search from my web application it only brings back results from one of the table. What is the best way to run a full text search on multiple tables that are related? I am a beginner and would appreciate any help/guidance that anyone can give. |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-24 : 16:45:16
|
| How are they realted?? One possibilty is to make a view that selects from one table and union all to the 2nd table. Then full text catalog on the view. Would you be able to show how the 2 tables are related?-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
Eliza
Starting Member
2 Posts |
Posted - 2002-10-25 : 09:32:03
|
| I know how to create a full text catalog on a table through the Enterprise Manager. How do you do it for a view? The relationship between the tables is one to many. |
|
|
|
cbn
Starting Member
11 Posts |
Posted - 2002-10-25 : 10:53:23
|
| If you look at the following discussion:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=20802In order to search use Select .......... INNER JOIN ...... then use LIKE '%" & request("my_searched_field") & "%' this '%" & request("field_from_form_2") & "%' comes either from your form or whatever variable you assigned to the searched string. |
|
|
|
|
|
|
Full Text Searching Multiple Tables