BorlandTalk.com

Ron Sawyer · Guest

I admit it. I'm an SQL moron. Never did much with it. And now I'm
building a very simple app for my mother to manager her recipes. The
database structures are:

Document Table
--------------
int DocID
String(255)Document Name

Word Table
----------
int WordID
String(40)Word

Dictionary Table
----------------
int DocID
int WordID

When a recipe is added it is placed in the Document Table with an ID of
X
Each word is extracted and is placed in the Word Table with and ID of Y
A record is then added tot he Dictionary table with placing X and Y in
the correct fields

The use cases for the search are:

1. Select all documents with ANY of the words asked to be searched
2. Select all documents with ALL of the words asked to be searched.

Can you help me write the SQL statements? The first one doesn't seem to
difficult. The second one seems tougher.