Inner Joins

I am having an issue show data. It seems that when I try to make an inner join in server connect, it does not show the correct data. The joins are set up correctly (As I have tested the in both MyphpAdmin, Datagrip, MYSQL). Is the an issue with this? Can someone direct me to or explain in detail how to set up an inner join, in server connect from two tables?