14 Replies Latest reply: Jul 18, 2013 2:26 PM by Mambi Badi RSS

    exclude value

    Mambi Badi

      Hi,

      i have 2 tables :

       

      ALLProducts:
      LOAD * INLINE [
           id, name,category
           10, Product1,2
           11, Product2,3
           12, Product3,2
           13, Product4,1
      ];


      BannedProducts:
      LOAD * INLINE [
           id, name,category
           10, Product1,2
      ];
       

      i want to get only the list of products that are nor banned

      i tried where not exists but doesn't work , is there any other function ?

      any idea ?