Searching Multiple tables

[michael calwell]

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