I'm trying to figure out the code to select cust_id where item_id is between 76 and 78 but not those with 79. My desired results would be:
pkid cust_id item_id
5 102 78
6 102 76
7 103 76
I initially thought to create a table with all items between 76-78, then find all with those not between 76-78, join them, and then delete these items from the original table (which would leave only those between 76-78 without any other numbers). But this felt very labor intensive and unproductive... leading me to think there must be a better way.
Don't worry about it. You actually have the hardest part down. Trying to state what you want to do clearly and completely is half the battle. After that it is just a matter of translating that to SQL syntax.