3 Replies Latest reply: Oct 26, 2017 9:33 AM by Julien Le Berre RSS

    Outer join

    Julien Le Berre

      Hello

       

      I would like to merge 2 tables like this:

       

      tab1: (A+B = Primary key)

      A, B

      1, a

      1, b

      2, c

      3, c

      -, d

      - e

       

      tab2: (A = Primary key)

      A, C

      1, xx

      2, yy

      3, zz

       

      result -> tab3:

      A, B, C

      1, a, xx

      1, b, xx

      2, c, yy

      3, c, zz

      -, d, -

      -, e, -

       

      Can I use a outer join?


      tab3:

      load * resident tab1 outer join load * resident tab2


      I'm not sure that "-,d" and "-,e" entries of tab1 will be present in tab3


      thanks!