JOIN Operation Error (Maria DB) : [This the QUERY I have done using normal WHERE condition][1]


[This the Same process done with JOIN, but yields error][2]


  [1]: https://i.stack.imgur.com/zT7ld.jpg
  [2]: https://i.stack.imgur.com/OcJOx.jpg

What am I doing wrong here ?. Please suggest the correct solution.

Thank you.