Just a guess: Maybe there is no data in your tblHistoricRFID ("r") that corresponds to your tblHistoricPallets ("h")? It's hard to tell since you're not selecting any of the "r" data, but all "p" (tblPalletTypes) data in your screenshot is null which would be the case if there is no corresponding data in "r" for "p" to join on.