want to get rid of a sequence

i have a query that im having trouble with. in my results for the table look like this:

sequence  &nbsp &nbsp type
------------ &nbsp -----
1              &nbsp proj
1            &nbsp &nbsp ro-1
1          &nbsp &nbsp &nbsp ro-2
2            &nbsp &nbsp ro-2
2            &nbsp &nbsp ro-1

if a sequence has a type "proj" associated with it, i do not want to display it. in this case, i only want to display sequence "2"

the query i have is:

select distinct seq, type from wotable where type <> 'proj' order by seq

right now, it displays the sequence "1" and just displays the type "ro-1" instead of project.

is there a way to display just the sequence "2" in this case?

SELECT * FROM wotable WHERE sequence NOT IN (SELECT sequence FROM wotable WHERE type = 'proj')

i.e. in the "NOT IN" subquery I select all IDs WITH type = 'proj' and in the higher leve query I select all the records which do not belong to that group of records

Voilà!

thanks...that worked