SQL grouping question
Posted on 2009-07-01
I have a table with these fields. (item_num, location, and value)
Each item_num might have many entries, each with a different location for the item.
Only one of the item locations should have a value of true (1). All others should have
a value of false (0). This lets me know the primary location for the item. All the other
locations for that item will have a 0 and be secondary locations.
What I want to know is which item_num (item numbers) have all location values of 0 and none with 1.
Show me all item_num where there is no 1 value set for any of the locations.
Can someone tell me the SQL statement for this please?