restrictive WHERE-IN

Hi everybody

Is there any way to have a restrictive where-in query?

Table1:
person_id value_id

1                1
1                2
1                3
1                4
2                1

If i now
SELECT * FROM PERSON WHERE VALUE_ID IN (1,2,3,4) i get person 1 and 2

is there any way to return person 1 only, because person 1 has every value.

Thanks in advance

Joerg Received on Sat Jun 26 1999 - 12:49:08 CDT