6 Replies Latest reply: Nov 21, 2013 2:21 PM by mayilvahanan ramasamy RSS

    Select "no Match Data"

    Alexandre Lourenço

      I need some help!!!!

       

      I have two tables. The first one contains all products, the second one contains just some of them with other information.

       

      Both have the same ID Product.

       

      I want to select just the products that ARE NOT in the second table, but every selection I tried, or I had all lines, or I had the match points.

       

      How do I do this?

       

      It will nice if I get to create a Field as "Not in the second" or "In the second".