FREETEXTTABLE

[DomTrix]

Hi there,

I am setting up a search functionality on my database. The search will be used to search products. We have a products table with full text searchable fields 'description' and 'title'.

I can set up a search query to search these fields using FREETEXTTABLE no problem.

I also have a couple of related tables, e.g. Author table.
The author table contains 'authorID' and 'authorName', and is linked to the product table with authorID.

I can setup a search query to search for products against the author name, no problem.

My problem:

I want to search both tables at the the same time and order the results by relevence (RANK). So the search looks at the author name in the author table, and the description and title in the product table (making sure they are connected) and returns the results in a single record set.

Any suggestions?

Thanks in advance,

DT

 

[DomTrix]

Ah, solved it. I was trying to use a UNION to combine multiple queries but running into all sorts of bizarre errors. Then saw someone talking about UNION ALL. Low and behold it worked