7 Replies Latest reply: Oct 27, 2017 7:45 AM by kulwant singh RSS

    Missing records using Outer Join

    chu ying kok

      Hi,

       

      I have met some issues with Outer Join.

      While working on small tables, it does work properly. However, when I tried joining 2 big tables with 4 data fields in common, there are some missing keys and records.

       

      Given an example below, the record boxed in red (while joining 2 tables with many columns) went missing. Any idea what's wrong?

      Picture2.png

      Kindly advise if you have met such problem before. Thanks in advance!