2 Replies Latest reply: Oct 31, 2012 10:32 AM by jagan mohan rao appala RSS

    Cleaner WHERE Clause

    Chirag Chhatralia

      Hi, 

       

      My question is hopefully a basic one regarding having less script to get to the same thing.  Currently I am doing the following

       

      Load *;

      From TableA

      WHERE OrderType = "A" AND OrderClass = 71

      OR OrderType = "A" AND OrderClass = 85

      OR OrderType = "A" AND OrderClass = 91;

       

      Is there a simplier way to write this i.e. in SQL it would be something like

      WHERE OrderType = 'A' AND OrderClass IN (71, 85, 91)

       

      Many thanks

      C