I have created a DB in mysql containing four table. i wanted to join all the tables based on some conditions and expecting to get one single consolidated table. But in between i am facing one problem. Please find the attached file.
Please suggests me the query or any idea to get the expected result.