Results 1 to 2 of 2

Thread: all column except for 2

  1. #1
    Join Date
    Nov 2005
    Location
    Seattle
    Posts
    5

    all column except for 2

    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 of 'tent'. How do I go about doing this? <> 'Tent','Umbrella'; is what I have tried, but it wasn't successful

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    See answer in the other forum where you posted this question.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •