Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct b.profname from committee b
- where not exists (
- select commname from committee a
- where a.profname = 'piper' and not exists (
- select commname from committee c
- where c.profname=b.profname and c.commname=a.commname
- )
- );
- select distinct b.profname from committee b
- where not exists (
- select commname from committee a
- where a.profname = 'piper' and not exists (
- select commname from committee c
- where c.profname=b.profname and c.commname=a.commname
- )
- );
- select distinct b.profname from committee b
- where not exists (
- select commname from committee a
- where a.profname = 'piper' and not exists (
- select commname from committee c
- where c.profname=b.profname and c.commname=a.commname
- )
- );
Add Comment
Please, Sign In to add comment