From: Guy Bassan <gbassan@unm.edu>
Subject: Re: Query help (brain went on strike)
Date: 1996/08/08
Message-ID: <320A350E.167EB0E7@unm.edu>#1/1
references: <32094113.341F@medicalogic.com>
content-type: text/plain; charset=us-ascii
organization: University of New Mexico, Albuquerque
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.02 (X11; I; SunOS 4.1.4 sun4m)



For the case with two criteria (cancer and skin, for example), you could
do this:

    SELECT x.id, x.keyword
    FROM words x, words y
    WHERE x.id = y.id and x.keyword = 'cancer' and y.keyword = 'skin'

You could write something similar for three or four criteria also.  If
you wanted to do N criteria in general, it would be different, but I
don't know if you need more than this.

			-- Guy Bassan
			-- Los Alamos National Laboratories