Looks like you need to join on multiple fields. Pl attach a workbook
I agree with Deepak.
Also, instead of using the 'paper clips' to join the data, try using Data > Edit Relationships. This method is a little easier to visualize and join fields that aren't necessarily named the same.
Please attach your workbook. Looks like you are using the LOD expressions or Table calculations.