4 Replies Latest reply: Mar 6, 2014 3:01 AM by Joaqu�n L�zaro RSS

    Handling null values

    vijeta sharma

      Hi everyone,

      I am having data like,

      table1:

      ID, cat

      1,aaa

      2,bbb

      3,ccc

      4,ddd

      and

      table2:

      ID, cat1

      1,

      2,bbb

      3,

      4,

      but,when i am joining these two table it gives me output like,

      ID,cat cat1

      1,aaa,-

      2,bbb,bbb

      3,ccc-

      4,ddd,-

      and I want output like

      ID,cat,cat1

      1,aaa,aaa

      2,bbb,bbb

      3,ccc,ccc

      4,ddd,ddd

      how I will achieve this output