11 Replies Latest reply: Dec 13, 2017 9:07 AM by Anand Chouhan RSS

    the best way to exclude the value by joining of tables

    Beck Bakytbek

      Hi Folks,

       

      I have a question: there are 2 Tables

       

      Tab_A

      ID, Sales

      A, 1

      B, 2

      D, 3

       

      and

       

      Tab_B

      ID, Sales

      A, 10

      B, 12

      C, 13

       

      The expected output is:

       

      Tab

      ID, Sales

      D,3



      what is best way to exclude the values and still only D = 3

       

      Thanks a lot

      Beck