Order by using an Inner Join not working in Linux environment of Mysql

Waiting for the reply… pls help