Null values after a JOIN

[absekrafi]

Dear Qlikview community,

I did a normal JOIN on 2 tables but I got the mesures fields shifted to where there is no corresponding value of the dimensions.

My mesures are: QTEPROD, QTEREDPROD and QUANTPRODTOTAL

and my dimensions are: CODUSN, CODEMP, CODESMP, CODPROD, CODSPROD, TYPEART AND TRANSCATION DATE.

Enclosed the table boxes of both Tables.

Do I have to use an other type of JOIN?

Please help me.

Thank you in advance,

Abdallah