I need help writing a query. Here's the data I have:
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:
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.
asked Aug 13 '12 at 08:30 PM in Default