Re: Query help (brain went on strike)

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