469,643 Members | 1,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,643 developers. It's quick & easy.

Searching Multiple tables

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
Jul 19 '05 #1
0 1108

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ralph Guzman | last post: by
reply views Thread by michael calwell | last post: by
1 post views Thread by Robert Oschler | last post: by
33 posts views Thread by Geoff Jones | last post: by
reply views Thread by qudra | last post: by
5 posts views Thread by Jerim79 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.