Dear all,
I have googled until my eyed have fallen out, and still I cannot find
what I am looking for, and I would be grateful for any help at all. I
can redesign my tables, create new fields etc, if needs be.
I have 2 tables. One contains a foreign key to another table.
Table: Names
===========
NameID | Name | JobDescription | LocationID
--------------------------------------------------------------
1 | John | farmer | 1
2 | Steve | carpenter | 3
3 | Frank | plumber | 2
Table: Locations
=============
LocationID | Name
=============
1 | America
2 | Canada
3 | Mexico
I want to do a full text search on both tables. I have created a
FULLTEXT index on Names, using 'Name' and 'Job Description'. I have also
created a fulltext index on Locations using Name.
I want to do a search like " return NameID where Names.Name,
Names.JobDescription, Locations.Name contain 'fred'.
*In other words, as though Locations.Name were a part of the Names Table.*
I can do a straighforward MATCH>AGAINST on the Names table, but how to
incorporate the Locations table?
Any help would be gratefully received.
Michael Calwell