4 Replies Latest reply: Sep 30, 2011 6:05 AM by Sunil Kenth RSS

    Help with expression syntax

    Sunil Kenth

      Hi - simple query here for you experts!

       

      I want the exclude data through the load script.  I can do it for one value:

       

      WHERE NOT MARKET = 'INTERCOMPANY' ;

       

      this works fine, but if want to exclude multiple then i am trying to use the following:

       

      WHERE NOT MARKET = 'INTERCOMPANY' OR 'EXPORT'; 

       

       

      But this doesnt work - do you know what the right syntax is?