3 Replies Latest reply: May 9, 2013 8:28 AM by Mohit Sharma RSS

    is null issue

    Sukhwant Matharoo

      hi all i have a script below:

       

      table 1:

      id             value

      a                10

      b               15

      c                   20

       

      table 2:

      id          category

      a               xyz

      b              

       

       

      Desired output is as :

      final:

      id          value         category

      b          15                   

       

       

       

      script is :

       

      test:

      load id, value from table 1;

      left join

      load id, category from table 2;

       

      final:

      load id, category, value resident test where isnull(category);

       

       

       

      the output i get is:

      id          value          category

      b          15

      c          20

       

       

      please help how to get Desired output

       

      thanks in advance