Sometimes JOINS can be confusing. What's the difference with the two queries below? Why it will bring different results?
left join PK2 ON PK2.PNN = PK1.PNN AND PK2.MANT = PK1.MANT";
left join MSS ON dbo.MSS.RSM = PK2.GBT AND dbo.MSS.MANT = PK2.MANT
left join PK2 ON PK2.GBT = MSS.RSM AND MSS.MANT = PK2.MANT
left join PK1 ON PK1.PNN = PK2.PNN AND PK1.MANT = PK2.MANT