SQL内连接不显示数据

I am new to php so please could someone take a look at this php code and explain/edit why the inner joins do not display the information required in query2.I am new to php so please could someone take a