Where-Bedingung über einen Status

[dataspider]

das sollte mit exists gehen:
select distinct(d.person) from details d where
exists (select * from details where person=d.person and status = 'S1') and
exists (select * from details where person=d.person and status = 'S3') and
not exists (select * from details where person=d.person and status = 'S2')
Cu, Frank