My question is how do I properly enter the information. I'm working on an exercise for class and I can get one item to be deleted from the list. I enter the following information:

select,customerid,item from item_ordered where item <> 'Tent';

I want to make the string remove the catagory, 'Umbrella' along with the catagory named 'tent'. I have learned how to remove one item from a column, but how do you apply this technique to two or more items as well.

I have tried a variety of different configurations using the <> path and have not tried any others. Am I logically thinking this through?

-Ron