How would you write this query...

I need help writing a query. Here's the data I have:

ticketnumber   status
------------   ------
123            0
123            16
456            16
789            0
234            0
345            0
678            16

I want to find all of the records for each ticketnumber that do not have at least a status of 0. So, 123 is ok because there's a record for 123 with a status of 0. 456 is not ok because there is only a record with a status of 16. 678 is not ok either.

The output based on the sample input should be:

ticketnumber
------------
456
678

I'm thinking I will need to do a self join. I'm not quite sure of how to proceed.

Any help would be appreciated.

Thanks,

Seth