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

    Missing records using Outer Join

    chu ying kok



      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?


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