Below is a snippet of a query which I am running.
These are two fields from a query that are related to hazardous material packages that I am tracking. What we have is a tracking number(so in this example there are two unique tracking numbers = 2 packages) and F3 which means if the package was scanned a certain way. I want to know of any package where all the F3 values are zero. There are hundreds of unique tracking numbers, but I just copied a couple to keep it simple.
What method would I use to approach this?
TrackingNumber F3
2 1Z4519380355990662 0
3 1Z4519380355990662 1
4 1Z4519380355990662 1
5 1ZW811R80342066082 0
6 1ZW811R80342066082 0
7 1ZW811R80342066082 0