Query help (brain went on strike)

I have two tables.

Table prob has two fields: description (character) and id (integer).

Table words has two fields: id (integer) and keyword.

The purpose of the prob table is to hold a list of medical problems (described). The purpose of the words table is to hold a list of words (0 to N rows for each row in prob) that are related to a prob. Thus someone could search on cancer in the words table and get back a list of problems from the prob table. (thru the id field)

I have that query.

What if I want to get back a list of problems that are both cancer and skin. I do not want rows from the words table that have cancer or skin. I want rows that have the same id and cancer or skin. Thus,

id keyword
1 cancer
1 skin

if the words table looks like thus
id keyword
1 cancer
1 skin
1 heme
2 skin
3 cancer

Any help would be appriciated.

Jim Kennedy
(jim_kennedy_at_medicalogic.com) Received on Wed Aug 07 1996 - 00:00:00 CEST