473,573 Members | 2,686 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.JobDescri ption, 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 1115

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1751
by: Ralph Guzman | last post by:
I have to do a catalog search through multiple tables and columns for product model number, description, and name. I realize that doing pattern matching with multiple LIKE statements is slow so I found that FULLTEXT searches is a better alternative. I have added a FULLTEXT index to the tables I'm searching, but I get an unkown error when I...
1
2407
by: Robert Oschler | last post by:
I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). I'm using MySQL 4.2.x. Here's my dilemma. 1) --------- I have two tables that have records with a FULLTEXT index text field in each of them. ...
6
1836
by: calan | last post by:
Relative SQL newbie here......this is probably easy, but.... Lets say I have a table (MainTable) that stores a list of input table names, a primary key (PKey), and a field called "Configured" for each one. Each of these input tables also contain a field called "Configured", which is set to true or false in another process based on an...
3
6005
by: Katrina | last post by:
I am trying to write a piece of code that will search through a number of different tables (current one being tableNm) to look for a specific street name that has been entered by the user and saved as Enteredstreet. If the street is found I then want to display a message box saying what table the street name is in. The code I am currently...
5
8820
by: David Wender | last post by:
I want to create a dataview with a sort on multiple columns. However, when I use FindRows, I only want to search some of the columns, not all. Is this possible? I have not been able to make it happen. Dim objKeys(2) as Object objKeys(0) = "CL" objKeys(2) = 4000 Dim posView As DataView = New DataView(posDS.Tables("Positions"), _
33
2456
by: Geoff Jones | last post by:
Hiya I have a DataTable containing thousands of records. Each record has a primary key field called "ID" and another field called "PRODUCT" I want to retrieve the rows that satisy the following criteria: I have a list of about 100 numbers which correspond to the ID field and also another 40 say numbers corresponding to the numbers in the...
7
4531
by: john | last post by:
In my form I have a master table and a details table linked 1xM. I can search through the whole parent table but I also like to be able to search through the child table fields to find parent records. Should I design a new form for this or can I somehow make this work in the same form. Thanks in advance, john
0
1195
by: qudra | last post by:
Searching multiple records -------------------------------------------------------------------------------- Hi guys. I need ur help. In VB.NET we usually use this code to search the database through windows application: CODE:::::: private sub btnSearch_click(--) dim empno as byte empno=inputbox("Enter emp no") dim r as datarow
5
1492
by: Jerim79 | last post by:
I am trying to create a search system for an existing database. Because of the way the database is setup, I need to traverse three different tables, gathering information: 1) Go into table1 and lookup show_id by show name. (For instance, let's say I am looking for the Mickey Mouse show. I look it up and find that it's show_id is 6) 2) Go...
0
7746
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7668
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8179
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7736
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8036
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3701
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3699
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2167
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1269
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.