4 Replies Latest reply: Apr 26, 2016 7:51 AM by Stefan Wühl RSS

    Make zeroes instead of null, while making left join

    Evgeny Stuchalkin

      Hi!

      i'm left-joining two tables, like

       

      IdStuff
      1a
      2b
      3c

       

       

      IdMeasure
      111
      222

       

      Result what i get is like:

      IdStuffMeasure
      1a11
      2b22
      3c-

       

      Resul what i want is:

       

      IdStuffMeasure
      1a11
      2b22
      3c0

       

      how i can achieve it?