I have two tables header and line. I am simply joining the tables with PI_DocumentNO which is common in both tables. But unfortunately some data in the field which has same data in common doesn't joins.
Please find the screenshot. I had added another PI_DocumentNO with name header in first table and Line in second table.
