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




      Desired output is as :


      id          value         category

      b          15                   




      script is :



      load id, value from table 1;

      left join

      load id, category from table 2;



      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